Statement showing Computations | ||||
Period | Payment | Interest | Balance reduction | Unpaid balance |
- | XXXXXXX | XXXXXXX | XXXXXXX | 5,600.00 |
1.00 | 2,412.10 | 784.00 | 1,628.10 | 3,971.90 |
2.00 | 2,412.10 | 556.07 | 1,856.03 | 2,115.87 |
3.00 | 2,412.10 | 296.22 | 2,115.87 | (0.00) |
Cam you please hand write. please i need the answers 13) A loan of $5,600 with...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $180,000 for 3 years at 7% compounded annually Period Payment Interest Balance Reduction Unpaid Balance $180,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $0.00
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $10,000 for 1 year at 12% compounded quarterly Period Payment Interest Balance Reduction Unpaid Balance $10,000 1 $ 2 $ 3 $ 4 $0.00
A loan of $1730 at 9.75% interest compounded semi-annually is to be repaid in four years in equal semi-annual payments. Complete an amortization schedule for the first four payments of the loan. Adjust the final payment so the balance is zero. Fill out the amortization schedule below. (Round to the nearest cent as needed. Do not include the $ symbol in your answers.) Payment Amount of Interest for Portion to Principal at Number End of Payment Period Principal Period $1730...
1. -15 points HarMathAp12 6.5.009 Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $80,000 for 3 years at 6% compounded annually Interest Balance Reduction Unpaid Balance PeriodPayment $80,000 2 $0.00
1. -15 points HarMathAp12 6.5.009 Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $80,000 for 3 years at 6% compounded annually Interest Balance Reduction Unpaid Balance PeriodPayment $80,000 2 $0.00
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $100,000 for 3 years at 8% compounded annually Period Payment Interest Balance Reduction Unpaid Balance $100,000 4 4 $0.00 Need Help? Read It Talk to a Tutor 10. -11 points HarMathAp 126.5.025. A couple who borrow $50,000 for 20 years at 8.4%, compounded monthly, must make monthly payments of $430.75. (Round your answers to the nearest cent (a) Find their unpaid balance after 1 year...
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $100,000 for 3 years at 10% compounded annually Period Payment Interest Balance ReductionUnpaid Balance $100000 $0.00
1. + -/15 points HarMathAP12 6.5.011. Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $30,000 for 1 year at 12% compounded quarterly Period Payment Interest Balance Reduction Unpaid Balance $30,000 $0.00 Need Help? Read Talk to a Tutor
please show excel syntax
Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $20,000 for 1 year at 12% compounded quarterly Balance Reduction Unpald Balance Perlod Payment Interest $20,000 1 $ $ 3 4 $0.00 Need Help? Read It Talk to a Tuter
b.
Fill in the partial amortization schedule for the loan, rounding
your answers to two decimal places.
General Computers Inc. purchased a computer server for $58,500. It paid 35.00% of the value as a down payment and received a loan for the balance at 7.50% compounded semi-annually. It made payments of $2,050.27 at the end of every quarter to settle the loan. a. How many payments are required to settle the loan? o payments Round up to the next payment...
2) You have received a 3-year $10,000 loan from your bank. This is an amortized loan which means you have to make 3 equal annual payments to the bank. The bank is charging you 12% APR (annual percentage rate) for this loan. a. Complete the following amortization schedule. (25 points) Amortization schedule Beginning Balance Annual Payment Interest Balance Reduction year End Balance Expense $10,000 $0.00 How much in total you end up paying back to the bank? (5 points) Assume...