Trusted by Students Everywhere
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

Finance Aug 22, 2020

(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
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment