The Questions Part One

User Generated

Whunzc09

Business Finance

Description

Please provide the solutions to the following questions. No other documents required. Please attach file in response.

Unformatted Attachment Preview

Q1. Create a car Loan Calculator with the following Input/Output: (see figure -1) Loan Amount:20000 Term in years: 5 Years Annual interest rate: 2.5% Down payment:4000 Your output Shows: The monthly payment Total amount to pay off the car loan (after 5 Years) Total interest paid towards the loan Figure - 1 Input 20,000 5 2.5% 4000 Loan Amount Term (Years) Annual Interest Rate Down payment Output Monthly payment Total amount to pay off the loan Total interest paid towards the loan Q2. Create a single input data table to display all results cells for Annual Interest Rate between 2.5% and 6% in quarter percent increments. Shown in Figure -2. Monthly Total amount to pay Total interest paid APR % payment off the loan towards the loan 2.50% 2.75% 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.259 5.5096 5.75% 5.0096 B2 LA BSS Q3. Create a two-input data table to show monthly payments for each Loan option amount and interest rate shown in Figure -3. Loan Loan Loan Loan Loan Loan Loan Opti Opt2 Opt3 Opt4 Opt5 Opt6 Opt7 APR% 20000 25000 30000 35000 40000 45000 50000 2.50% 2.75% 3.00% 3.25% 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00%
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

See attached

Car Loan Calculator
INPUT
Loan Amount
Term(Years
Annual Interest Rate
Down Payment
OUTPUT
Monthly Payment
Total Amount to Pay off the Loan
Total Interest paid towards the loan

APR%
$

20.000,00
5
2,50%
4000

$354,95
21296,83
1296,83

2,50%
2,75%
3,00%
3,25%
3,50%
3,75%
4,00%
4,25%
4,50%
4,75%
5,00%
5,25%
5,50%
5,75%
6,00%

Monthly
Total ...


Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags