Homework Answers
Annaul Instalment = Loan Amount / PVAF(r%, n)
PVAF(r%, n) = Sum of PVF(r%, n)
PVF(r%, n) = 1 / (1+r)^n
Annaul Instalment = Loan Amount / PVAF(r%, n)
= $2,000,000 / 7.3601
= $ 271,735.92
Amortization Schedule:
| Year | Opening Balance | Annual Payment | Annual Int | Principal repay | Ending Balnce |
| 1 | $ 20,00,000.00 | $ 2,71,735.92 | $ 1,20,000.00 | $ 1,51,735.92 | $ 18,48,264.08 |
| 2 | $ 18,48,264.08 | $ 2,71,735.92 | $ 1,10,895.85 | $ 1,60,840.07 | $ 16,87,424.01 |
| 3 | $ 16,87,424.01 | $ 2,71,735.92 | $ 1,01,245.44 | $ 1,70,490.48 | $ 15,16,933.54 |
| 4 | $ 15,16,933.54 | $ 2,71,735.92 | $ 91,016.01 | $ 1,80,719.90 | $ 13,36,213.63 |
| 5 | $ 13,36,213.63 | $ 2,71,735.92 | $ 80,172.82 | $ 1,91,563.10 | $ 11,44,650.53 |
| 6 | $ 11,44,650.53 | $ 2,71,735.92 | $ 68,679.03 | $ 2,03,056.88 | $ 9,41,593.65 |
| 7 | $ 9,41,593.65 | $ 2,71,735.92 | $ 56,495.62 | $ 2,15,240.30 | $ 7,26,353.35 |
| 8 | $ 7,26,353.35 | $ 2,71,735.92 | $ 43,581.20 | $ 2,28,154.72 | $ 4,98,198.64 |
| 9 | $ 4,98,198.64 | $ 2,71,735.92 | $ 29,891.92 | $ 2,41,844.00 | $ 2,56,354.64 |
| 10 | $ 2,56,354.64 | $ 2,71,735.92 | $ 15,381.28 | $ 2,56,354.64 | $ -0.00 |
Pls comment, if any further assistance is required.
Add Answer to:
Problem 2 Boston Healthcare has just borrowed $2,000,000 on a ten-year, annual payment term loan at...
Suppose C&Y restaurant borrow a 5-year loan of $85,000 at an annual interest rate of 5%....
Suppose C&Y restaurant borrow a 5-year loan of $85,000 at an annual interest rate of 5%. The loan agreement states that the repayment of principal and the loan interest has to be paid by the end of each year. The instalment of each repayment is fixed amount throughout the loan period. You are instructed to construct an amortization schedule for loan repayment including beginning balance, annual payment, interest and ending balance.
Construct an amortization schedule for a $1,000, 10% annual rate loan with 3 equal annual payments....
Construct an amortization schedule for a $1,000, 10% annual rate loan with 3 equal annual payments. Step #1: Find the required annual payment on the loan. Step #2: Complete the amortization table for the loan. (4) = (2)-(3) (5) = (1)-(4) (3) = (1) * interest rate INTEREST EXPENSE PAYMENT YEAR PERIOD BEGINNING BALANCE PRINCIPAL REPAYMENT ENDING BALANCE
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of...
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual end-of-year payments Calculate the annual end of year loan payment b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a. The amount of the...
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $49 comma 00049,000 at a 66% annual...
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $49 comma 00049,000 at a 66% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual, end-of-year payments. a. Calculate the annual, end-of-year loan payment. b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a. The amount of...
Your company is planning to borrow $0.75 million on a 5-year, 14%, annual payment, fully amortized...
Your company is planning to borrow $0.75 million on a 5-year, 14%,
annual payment, fully amortized term loan.
The data has been collected in the Microsoft Excel Online file
below. Open the spreadsheet and perform the required analysis to
answer the question below.
What fraction of the payment made at the end of the second year
will represent repayment of principal? Do not round intermediate
calculations. Round your answer to two decimal places.
________ %
screenshot of spreadsheet attached just...
Your company is planning to borrow $0.75 million on a 5-year, 14%, annual payment, fully amortized...
Your company is planning to borrow $0.75 million on a 5-year, 14%,
annual payment, fully amortized term loan.
The data has been collected in the Microsoft Excel Online file
below. Open the spreadsheet and perform the required analysis to
answer the question below.
What fraction of the payment made at the end of the second year
will represent repayment of principal? Do not round intermediate
calculations. Round your answer to two decimal places.
__________%
the answer is not .5 92....
only need the second part B SECTION 5-18 Amortization 1. Suppose you borrowed $30,000 on a...
only need the second part
B SECTION 5-18 Amortization 1. Suppose you borrowed $30,000 on a student loan at a rate of 8% and must repay it in 3 equal installments at the end of each of the next 3 years. How large would your payments be, how much of the first payment would represent interest, how much would be principal, and what would your ending balance be after the first year? 8% $30,000 $0 FV PMT $8,386.69 3 Loan...
PROBLEM 4 Assume that you just won $35 million in the Florida lottery, and hence the...
PROBLEM 4 Assume that you just won $35 million in the Florida lottery, and hence the state will pay you 20 annual payments of $1.75 million each beginning immediately. If the rate of return on securities of similar risk to the lottery earnings (e.g., the rate on 20-year U.S. Treasury bonds) is 6 percent, what is the present value of your winnings? PROBLEM 5 Epitome Healthcare has just borrowed $1,000,000 on a five-year, annual payment term loan at a 15...
Question 5 Ten years ago you borrowed $258000. The term of the loan was 23 years...
Question 5 Ten years ago you borrowed $258000. The term of the loan was 23 years and required monthly payments of $2756.90. The interest rate on the loan was 12 percent compounded monthly. You have just made the 138th payment. What is the principal outstanding? $190069.34 $171546.34 $129000.00 $205855.27
(Round to the nearest cent) Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at...
(Round to the nearest
cent)
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual, end-of-year payments. a. Calculate the annual, end-of-year loan payment. b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time.
Construct an amortization schedule for a $1,000, 10% annual rate loan with 3 equal annual payments. Step #1: Find the required annual payment on the loan. Step #2: Complete the amortization table for the loan. (4) = (2)-(3) (5) = (1)-(4) (3) = (1) * interest rate INTEREST EXPENSE PAYMENT YEAR PERIOD BEGINNING BALANCE PRINCIPAL REPAYMENT ENDING BALANCE
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual end-of-year payments Calculate the annual end of year loan payment b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time. a. The amount of the...
Your company is planning to borrow $0.75 million on a 5-year, 14%,
annual payment, fully amortized term loan.
The data has been collected in the Microsoft Excel Online file
below. Open the spreadsheet and perform the required analysis to
answer the question below.
What fraction of the payment made at the end of the second year
will represent repayment of principal? Do not round intermediate
calculations. Round your answer to two decimal places.
________ %
screenshot of spreadsheet attached just...
Your company is planning to borrow $0.75 million on a 5-year, 14%,
annual payment, fully amortized term loan.
The data has been collected in the Microsoft Excel Online file
below. Open the spreadsheet and perform the required analysis to
answer the question below.
What fraction of the payment made at the end of the second year
will represent repayment of principal? Do not round intermediate
calculations. Round your answer to two decimal places.
__________%
the answer is not .5 92....
only need the second part
B SECTION 5-18 Amortization 1. Suppose you borrowed $30,000 on a student loan at a rate of 8% and must repay it in 3 equal installments at the end of each of the next 3 years. How large would your payments be, how much of the first payment would represent interest, how much would be principal, and what would your ending balance be after the first year? 8% $30,000 $0 FV PMT $8,386.69 3 Loan...
PROBLEM 4 Assume that you just won $35 million in the Florida lottery, and hence the state will pay you 20 annual payments of $1.75 million each beginning immediately. If the rate of return on securities of similar risk to the lottery earnings (e.g., the rate on 20-year U.S. Treasury bonds) is 6 percent, what is the present value of your winnings? PROBLEM 5 Epitome Healthcare has just borrowed $1,000,000 on a five-year, annual payment term loan at a 15...
Question 5 Ten years ago you borrowed $258000. The term of the loan was 23 years and required monthly payments of $2756.90. The interest rate on the loan was 12 percent compounded monthly. You have just made the 138th payment. What is the principal outstanding? $190069.34 $171546.34 $129000.00 $205855.27
(Round to the nearest
cent)
Loan amortization schedule Personal Finance Problem Joan Messineo borrowed $46,000 at a 4% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual, end-of-year payments. a. Calculate the annual, end-of-year loan payment. b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time.
Most questions answered within 3 hours.
-
How would you train your employees to avoid risks of using
mobile devices?
asked 16 minutes ago -
Assume Kw = 1.01 ✕ 10−14
For pure water, we can calculate [H3O+ ] = [OH...
asked 1 hour ago -
Suppose that on a temperature scale X, water boils at 203.0°X
and freezes at -105.7°X. What...
asked 2 hours ago -
BaS crystallizes in a cubic unit cell with S2- ions on each
corner and each face....
asked 2 hours ago -
A. 0≤P(Oi)≤10≤P(Oi)≤1 for each i
B. P(Oi)≤0P(Oi)≤0
C. P(Oi)=1+P(OCi)P(Oi)=1+P(OiC)
D. P(Oi)≥1P(Oi)≥1
If an experiment consists of...
asked 4 hours ago -
A battery has an emf of 9.20V and an internal resistance of 1.20
ohm. a)What resistance...
asked 4 hours ago -
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 5 hours ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 6 hours ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 6 hours ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 6 hours ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 6 hours ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 7 hours ago