Question
In: Finance
A 5-year, 10%, $500,000 loan requires equal principal payments in years 4 and 5 ($250,000 each...
A 5-year, 10%, $500,000 loan requires equal principal payments in years 4 and 5 ($250,000 each year). Show the cash flows (interest and principal payments) for years 1-5.
Solutions
Expert Solution
| Years | Cash OutFlow | Interest | Loan Repayment | Cumulative Balance |
| 0 | $ 5,00,000 | $ - | $ 5,00,000 | |
| 1 | $ 50,000 | $ 5,50,000 | ||
| 2 | $ 55,000 | $ 6,05,000 | ||
| 3 | $ 60,500 | $ 6,65,500 | ||
| 4 | $ 66,550 | $ 4,82,050 | $ 2,50,000 | |
| 5 | $ 25,000 | $ 2,75,000 | $ - | |
| Total | $ 2,57,050 | $ 7,57,050 | ||
| total Interest Payment = | $ 2,57,050 | |||
| Prinicipal Amount = | $ 5,00,000 | |||
| Year 4 Payment = $ 250,000 + $ 50,000 + $ 55,000 + $ 60,500 + $ 66,550 + $ 25,000 =$ 482,050 | ||||
jeff jeffy answered 2 years agoRelated Solutions
A $10,000 loan is to be repaid in monthly equal payments in 10 years with an...
A $10,000 loan is to be repaid in monthly equal payments in 10
years with an annual effective interest rate of 19.56% charged
against the unpaid balance. What principal remains to be paid after
the third payment?
Consider a $12,000 loan with 4 equal annual payments and 10% interest. a. Calculate the annual...
Consider a $12,000 loan with 4 equal annual payments and 10%
interest.
a. Calculate the annual payment, n = 4, r = 0.10.
b. Prepare a complete loan payment schedule table for this loan.
You need the time period, the beginning principal, payment,
interest paid, principal paid, and ending principal in your
table.
c. Now assume that the loan is fully amortized over 4 years,
however, the interest rate is variable. That is, the bank changes a
different rate each...
[SHORT] In Excel: Amount of the loan: $500,000 Length of the loan: 30 years Payment: Equal...
[SHORT] In Excel:
Amount of the loan: $500,000
Length of the loan: 30 years
Payment: Equal annual payment
Interest rate: Annual interest rate is 3.0% in year 1, and
increases at 0.1% increment every year after that. So Year 2's rate
will be 3.1%, Year 3's rate will be 3.2%, etc.
Create a year-by-year table with Year, Beginning balance, PMT,
interest, principal, and ending balance.
Make sure to create a column to reflect floating interest
rates.
Make sure to utilize...
A 10-year loan of 120,000 is to be repaid with payments at the end of each...
A 10-year loan of 120,000 is to be repaid with payments at the
end of each month. Interest is at an annual effective rate of
6.00%.
The first monthly payment is 800. Each additional payment will
be k more than the previous month payment. Find
k.
Fully amortized loan (annual payments for principal and interest with the same amount each year). Chuck...
Fully amortized loan (annual payments for principal and
interest with the same amount each year). Chuck Ponzi has talked
an elderly woman into loaning him $50 comma 000 for a new business
venture. She has, however, successfully passed a finance class and
requires Chuck to sign a binding contract on repayment of the $50
comma 000 with an annual interest rate of 11% over the next 10
years. Determine the cash flow to the woman under a fully
amortized loan,...
A firm borrows $5000 and the loan is to be repaid in 4 equal payments at...
A firm borrows $5000 and the loan is to be repaid in 4 equal
payments at the end of each of the next 4 years so that the ending
balance at the end of year 4 is 0. The interest rate on the loan is
10 percent. The principal repayment in year 3 is:
A firm borrows $5000 and the loan is to be repaid in 4 equal payments at...
A firm borrows $5000 and the loan is to be repaid in 4 equal
payments at the end of each of the next 4 years so that the ending
balance at the end of year 4 is 0. The interest rate on the loan is
10 percent. The beginning balance in year 2 is:
Loan of $20000 with interest at j2 = 10%, is to be amortized by equal payments...
Loan of $20000 with interest at j2 = 10%, is to be
amortized by equal payments at the end of each 6 months over a
period of 20 half-years. Using the Retrospective Method, Determine
the outstanding balance at the end of 12 half-years.
choose
25549.22
10374.36
10367.9
10. A 12% loan with semiannual payments for 30 years a.Would have payments twice a year....
10. A 12% loan with semiannual payments for 30 years
a.Would have payments twice a year.
b.Would have 330 payments.
c.Would have a rate of 1% per month.
d.Would have payments greater than $1,000 each.
e.Would be difficult to pay off in 30 years.
11. If a bond is callable January – June each year, then
a.The bond CANNOT be called on March 1.
b.The bond is call protected July – December each year.
c.The bond CAN be called on...
A loan of $10,000 is being repaid with 10 payments at the end of each year,...
A loan of $10,000 is being repaid with 10 payments at the end of
each year, where each payment includes equal amount of repayment of
the principal and the interest at a rate of 5% based on the
outstanding balance after the previous payment. Immediately after
the loan was made, the right of the loan was sold at a price that
yields an annual effective rate of 10%. Find the price paid for the
right of the loan. (Answer: $8072.28)...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Consider the following time series data: Month 1 2 3 4 5 6 7 Value 25...
- A) A body falls on the ground from a height of 10 m and rebounds to...
- Suppose Chance Chemical Products management conducts a study and concludes that if it expands into a...
- Joe Moxingo wrote an article about chuldren growing up in a run down motel in San...
- Briefly describe the informational cues based on which attributions are made.
- Service Modification and Development Assume the role of Service Marketing Manager of a specialized service company...
- 1. One way of accessing financial information about a company is to look it up at...
ADVERTISEMENT