Why Choose Us?
0% AI Guarantee
Human-written only.
24/7 Support
Anytime, anywhere.
Plagiarism Free
100% Original.
Expert Tutors
Masters & PhDs.
100% Confidential
Your privacy matters.
On-Time Delivery
Never miss a deadline.
(a) While vacationing in Langkawi, Martin Low saw the vacation home of his dreams
(a) While vacationing in Langkawi, Martin Low saw the vacation home of his dreams. It was listed with a sale price of $200,000. The only catch is that Martin is 40 years old and plans to continue working until he is 65. Still, he believes that prices generally increase at the overall rate of inflation. Martin believes that he can earn 9% annually after taxes on his investments. He is willing to invest a fixed amount at the end of each of the next 25 years to fund the cash purchase of such a house (one that can be purchased today for $200,000) when he retires.
Required: (i) Inflation is expected to average 5% per year for the next 25 years. What will Martin's dream house cost when he retires?
(ii) How much must Martin invest at the end of each of the next 25 years to have the cash purchase price of the house when he retires?
(iii) If Martin invests at the beginning instead of at the end of each of the next 25 years, how much must he invest each year?
(b) Susan Morse just closed a $10,000 business loan that is to be repaid in three equal, annual, end-of-year payments. The interest rate on the loan is 13%. As part of her firm's detailed financial planning, Susan wishes to determine the annual interest deduction attributable to the loan. (Because it is a business loan, the interest portion of each loan payment is tax-deductible to the business.)
Required:
(i) Determine the firm's annual loan payment.
(ii) Prepare an amortization schedule for the loan.
Expert Solution
a-i) Computation of the future value:-
FV = PV*(1+Rate)^n
= $200,000*(1+5%)^25
= $200,000*3.3864
= $677,270.99
ii). We can calculate the annual payment at the end of each year by using the following formula in excel:-
=pmt(rate,nper,pv,-fv)
Here,
Pmt = Annual payment at the end of each year
Rate = 9%
Nper = 25 periods
PV = 0
FV = $677,270.99
Substituting the values in formula:
= pmt(9%,25,0,-677270.99)
= $7,996.03
iii). We can calculate the annual payment at the beginning of each year by using the following formula in excel:-
=pmt(rate,nper,pv,-fv,type)
Here,
Pmt = Annual payment at the beginning of each year
Rate = 9%
Nper = 25 periods
PV = 0
FV = $677,270.99
Type = 1
Substituting the values in formula:
= pmt(9%,25,0,-677270.99,1)
= $7,335.81
b-i). We can calculate the annual loan payment by using the following formula in excel:-
=pmt(rate,nper,-pv,fv)
Here,
Pmt = Annual loan payment
Rate = 13%
Nper = 3 periods
PV = $10,000
FV = $0
Substituting the values in formula:
= pmt(13%,3,-10000,0)
= $4,235.22
Archived Solution
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





