Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Recently you purchased a nice car for $ 5 2 , 0 0 0 on January 1 , 2 0 1 . The dealer asked

Recently you purchased a nice car for $52,000 on January 1,201.
The dealer asked you to pay $2000 down and offered you financing for the remaining. The condition of
the financing was as follows:
Total period was 7 years.
Interest rate is 4.9%
Your payment should be at the end of each month.
Required to calculate your monthly payments using the appropriate time value of money formula
provided for you below. Do not use any other method such as Excel present value function as it would
has zero value for this project.
You must prepare the following schedule in Excel and fill in the numbers. Make sure DO NOT type the
numbers and rather transfer the cells.
Schedule of Loan Amortization
#of Period in years
# of period in months
Interest rate per year
Interest rate per month
Principle of the loan
Annuity (monthly payment)
?
?
?
?
?
?
Answer the following Questions:
Your total payment including $2,000 down payments:
Your total payment excluding down paymens:
Your total interest expense for the first year:
Your total interest Expense over 7-year period:
Total cost of the car that you purchased:
Please Note: again, for calculation of the Annuity, you must use the appropriate Time Value
of Money Formula provided below:
Time Value of Money Formulas:
Future Value of a single sum ,FV=PV(1+i) n
Present Value of a single sum PV=FV(1+i)
Future Value of an ordinary annuity FVOA=A((1+i)n-1i)
Present Value of an ordinary annuity {:PV0n=A(1-(11+ir)i))
Present Value of an annuity due ,PVAD=A(1+(1-1(1+i)n-1i))
Present Value of perpetual Annuity PVpA=Ai
Fundamental Variables
,i-Interest rate per period (month)
n-Number of time periods (months)
FV- Future value
PV- Present value
A-Annuity (mortgage)
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate Development Principles And Process

Authors: Mike E. Miles, Laurence M. Netherton, Adrienne Schmitz

5th Edition

0874203430, 978-0874203431

More Books

Students also viewed these Finance questions