Question

In: Finance

Quantitative Problem: You need $10,000 to purchase a used car. Your wealthy uncle is willing to...

Quantitative Problem: You need $10,000 to purchase a used car. Your wealthy uncle is willing to lend you the money as an amortized loan. He would like you to make annual payments for 5 years, with the first payment to be made one year from today. He requires a 5% annual return. What will be your annual loan payments? Do not round intermediate calculations. Round your answer to the nearest cent. $ How much of your first payment will be applied to interest and to principal repayment? Do not round intermediate calculations. Round your answers to the nearest cent

Interest: $ ??

Principal repayment: $ ??

Solutions

Expert Solution

Annual Instalment :
Instalment is sum of money due as one of several equal payments for loan/ Mortgage taken today, spread over an agreed period of time.

EMI = Loan / PVAF (r%, n)
PVAF = SUm [ PVF(r%, n) ]
PVF(r%, n) = 1 / ( 1 + r)^n
r = Int rate per period
n = No. of periods

How to calculate PVAF using Excel:
=PV(Rate,NPER,-1)
Rate = Disc Rate
NPER = No.of periods

Particulars Amount
Loan Amount $             10,000.00
Int rate per Anum 5.0000%
No. of Years 5

Annual Instalemnt = Loan Amount / PVAF (r%, n)
Where r is Int rate per Anum & n is No. of Years
= $ 10000 / PVAF (0.05 , 5)
= $ 10000 / 4.3295
= $ 2309.75
Annual Instalment = $ 2309.75

Loan Aortization schedule:

Period Opening Bal EMI Int Principal Repay Closing Outstanding
1 $             10,000.00 $         2,309.75 $               500.00 $            1,809.75 $                 8,190.25
2 $               8,190.25 $         2,309.75 $               409.51 $            1,900.24 $                 6,290.02
3 $               6,290.02 $         2,309.75 $               314.50 $            1,995.25 $                 4,294.77
4 $               4,294.77 $         2,309.75 $               214.74 $            2,095.01 $                 2,199.76
5 $               2,199.76 $         2,309.75 $               109.99 $            2,199.76 $                              -  

Opening Balance = Previous month closing balance
EMI = Instalment calculated
Int = Opening Balance * Int Rate
Principal repay = Instalment - Int
Closing Balance = Opening balance - Principal Repay

From Loan Amortization Schedle,

Int in First Payment = $ 500 ( $ 10000 * 5% )

Principal Repayment = $ 2309.75 - $ 500

= $ 1809.75


Related Solutions

Quantitative Problem: You need $11,000 to purchase a used car. Your wealthy uncle is willing to...
Quantitative Problem: You need $11,000 to purchase a used car. Your wealthy uncle is willing to lend you the money as an amortized loan. He would like you to make annual payments for 4 years, with the first payment to be made one year from today. He requires a 9% annual return. What will be your annual loan payments? Do not round intermediate calculations. Round your answer to the nearest cent. $   How much of your first payment will be...
You purchase a car for 10,000 The car loan is financed with a 5% per year,...
You purchase a car for 10,000 The car loan is financed with a 5% per year, 5 year loan with annyual payments starting at time 1 (1 year from today) through time 5 Each payment reduces the principal by a certain amount until the loan is completely paid off. What is the interest component of the first payment? (I am allowed to use the TI-34 and BAII Plus calculators)
You are given an old car by your uncle, who wants you to keep it in...
You are given an old car by your uncle, who wants you to keep it in working condition so that you can hand it off to your younger brother in three years. It will cost you $1,500 per year to keep it in working condition for your brother. If you skip maintenance altogether, the car will die after two years, but you can pocket the maintenance costs. a. What will you be tempted to do? Not do the maintenance, because...
Your wealthy industrialist brother is trying to persuade your retired uncle to buy shares in puma...
Your wealthy industrialist brother is trying to persuade your retired uncle to buy shares in puma Energy Limited which is listed on stock market? He himself owns a few thousand and is impressed by the steady rise in the price. Your uncle is skeptical because puma Energy pays out a very small dividend.Required: (i)What arguments is your cousin likely to make to your uncle? (ii)Are the arguments valid in this case?
I need to know about equations used and how to by hand! A. Quantitative Problem 1:...
I need to know about equations used and how to by hand! A. Quantitative Problem 1: Assume today is December 31, 2013. Barrington Industries expects that its 2014 after-tax operating income [EBIT(1 – T)] will be $400 million and its 2014 depreciation expense will be $60 million. Barrington's 2014 gross capital expenditures are expected to be $100 million and the change in its net operating working capital for 2014 will be $30 million. The firm's free cash flow is expected...
(2) Your wealthy Aunt offers you a graduation gift. She will give you a $10,000 lump...
(2) Your wealthy Aunt offers you a graduation gift. She will give you a $10,000 lump sum payment or 1,100/year for the next 10 years. This is essentially a risk free gift from your standpoint. The risk free rate currently sites at 2.5%. Which will you take? Why? Please use the financial principles from the chapter to make this decision. show your work.
You have saved $10,000 for a down payment on the purchase of a new car, however,...
You have saved $10,000 for a down payment on the purchase of a new car, however, since you plan to buy the car one year from today, you need to decide how to invest the money for one year. You are limited to one of two choices: 1. A Bond Fund with an expected return of 3%/year 2. A Stock Fund with an expected return of 7%/year. Which fund is best? Explain why!
You are deciding whether to lease or purchase a car. If you lease the car, your...
You are deciding whether to lease or purchase a car. If you lease the car, your annual payments will be $7,400 for the next four years (due at year end). If you buy the car, you will pay $30,000 to purchase the car. You estimate the car will have a resale value of $12,000 at the end of four years. Assume the appropriate discount rate is 10%. Should you lease or buy the car? To answer this question, assume the...
Your local auto store is willing to lease you a new car for $254 a month...
Your local auto store is willing to lease you a new car for $254 a month for 66 months. Payments are due on the first day of each month starting with the day you sign the lease. Using an APR of 8.50% compounded semi-annually, what is the present value of the lease? Question 1 options: $12,822 $13,160 $13,497 $13,834 $14,172
When you purchase a car, you may consider buying a brand-new car or a used one....
When you purchase a car, you may consider buying a brand-new car or a used one. A fundamental trade-off in this case is whether you pay repair bills (uncertain at the time you buy the car) or make loan payments that are certain. Consider two cars, a new one that costs $15,000 and a used one with 75,000 miles for $5,500. Let us assume that your current car’s value and your available cash amount to $5,500, so you could purchase...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT