Question

In: Finance

1. Loan Amortization problem - Bubba Gump’s new shrimp boat cost $70,000. He paid $25,000 up...

1. Loan Amortization problem - Bubba Gump’s new shrimp boat cost $70,000. He paid $25,000 up front and signed a 10-year, $45,000 mortgage at 11%.
a. What is the amount of each monthly payment?
b. Produce a loan amortization schedule for the first four payment periods.
c. What is the total interest Bubba will pay on this loan, assuming he pays it according to schedule?
d. Let’s say he comes into some dough and wants to pay off the loan immediately after making the 27th payment. How much does he owe at that point?

2. Retirement problem - When only a lad, Chase began investing $750 per month into a mutual fund that has earned on average 11% annually for the past 20 years.
a. How much is Chase’s account worth today?
b. Assume Chase decides to drop out of society and simply live off this investment. If he continues to earn 11% on the account, what is the maximum amount he can withdraw quarterly, assuming he plans to live 25 more years?

Solutions

Expert Solution

1. Loan amount = $45,000, rate = 11%, term = 120 months

a) Monthly payment can be calculated using PMT function in excel. =-PMT(11%/12, 120, 45000) = $619.88

b) Loan amortization table is below

Payment Opening balance Interest payment Principal repaid Closing balance
1 45,000 413 207 44,793
2 44,793 411 209 44,583
3 44,583 409 211 44,372
4 44,372 407 213 44,159

Opening balance (from month 2) = prior period closing balance

Interest payment = interest rate (11%) * opening balance

Principal repaid = monthly payment ($619.88) - interest payment

Closing balance = opening balance - principal repaid

c) Total interest paid can be calculated using CUMIPMT function in excel = -CUMIPMT(11%/12, 120, 45000, 1, 120, 0) = $29,385

d) Extending the loan amortization table to 27 months we get outstanding balance to be paid off = $38,680

Payment Opening balance Interest payment Principal repaid Closing balance
27 38,943 357 263 38,680

Related Solutions

Problem 5-50 Amortization Schedule (LG9) Create the amortization schedule for a loan of $4,300, paid monthly...
Problem 5-50 Amortization Schedule (LG9) Create the amortization schedule for a loan of $4,300, paid monthly over two years using an 9 percent APR. (Round your answers to 2 decimal places.)       Month   Beginning Balance   Total Payment   Interest Paid   Principal Paid   Ending Balance 1                               2                               3                               4                               5                               6                               7  ...
Problem 5-49 Amortization Schedule (LG9) Create the amortization schedule for a loan of $14,000, paid monthly...
Problem 5-49 Amortization Schedule (LG9) Create the amortization schedule for a loan of $14,000, paid monthly over three years using a 9 percent APR. (Round your answers to 2 decimal places.)    Month Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance 1                2                3                4                5                6                7...
Ian loaned his friend $25,000 to start a new business. He considers this loan to be...
Ian loaned his friend $25,000 to start a new business. He considers this loan to be an investment, and therefore requires his friend to pay him an interest rate of 9% on the loan. He also expects his friend to pay back the loan over the next four years by making annual payments at the end of each year. Ian texted and asked that you help him calculate the annual payments that he should expect to receive so that he...
1. Create a new Problem 1 worksheet and build up the Economic Order Quantity (EOQ) model...
1. Create a new Problem 1 worksheet and build up the Economic Order Quantity (EOQ) model as discussed in the slides. Use the following values for the model variables: Annual Demand: 105,000 Cost Per Unit: $27.38 Holding Costs: 7.5% Ordering Costs: $273.00 Make sure that your model calculates the Unit Holding Costs, EOQ and Orders to Place per Year. 2. Create a new Problem 2 worksheet and build up the Earned Value Management (EVM) model as discussed in the slides....
1. When a new college student moves into his dorm room he is woken up every...
1. When a new college student moves into his dorm room he is woken up every night by the train whistles from the nearby train tracks. After a few weeks he realizes that he sleeps through the night every night. What happened to this student? A. Habituation B. Plasticity C. long-term sensitization D. stimulus E. Short-term sensitization 2. A student interested in the molecular mechanism of learning would look for change in a synapse undergoing long-term potentiation? A. decrease in...
PROBLEM 3 Depreciation Yara Company purchased a new machine on 1 September 2007, at a cost...
PROBLEM 3 Depreciation Yara Company purchased a new machine on 1 September 2007, at a cost of $180,000. The machine’s estimated useful life at the time of the purchase was five years, and its residual value was $10,000. Yara adopts the cost model as its accounting policy in subsequently measuring its property, plant, and equipment. Instructions Prepare a complete depreciation schedule, beginning with calendar year 2007, under each of the methods listed below (assume that half-year convention is used): Straight-line....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT