Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $40,000 for 1 year at 12% compounded quarterly Period Payment Interest Balance Reduction Unpaid Balance         $40,000 1 $ $ $ $ 2 $ $ $ $ 3 $ $ $ $ 4 $ $ $ $0.00

Amortization Table - Breaking Down Your Payment - No video             This worksheet requires you to use the IPMT and PPMT funtions to calculate the loan balance, and the principle/interest portion of a loan payment at any given point in time. Be sure to use cell references.             Initial Balance   $10,000.00          Annual Interest Rate   10%         Years   10         Annual Payemnt   $1,627.45                      Summary loan data for year 4                     Balance at start of year           Balance at end of year           Interest paid during the year           Principle paid during the year

Subject: acounting

None

Amortization Table A loan of $11,000 is to be repaid over a 2-year period through equal quarterly installments with an interest rate of 13% per year compounded quarterly. Determine the size of each installment. Part 1 of 2 Use a TVM solver to solve this problem. Fill in the information that you typed into the TVM solver. Round the final answer to two decimal places. N = 1% = PV = 8 ✔ 13 11000 PMT= alpha ✔ 8 13 Final Answer: $1583.59 11000 alpha FV = P/Y = C/Y = 1583.59 o PMT: (End/Begin) End✔ ✔ Part 2 of 2 Verify the installment amount by filling in the amortization table. X 1583.59 1583.59 ✓ 1583.59 1583.59 ✔ 1583.59 ✔ 1583.59 ✔ 1583.59 1583.59 0 End of Period Interest Charged Repayment Made Payment Toward Principal Outstanding Principal 0 11000 ✓ 1 x 2 X 3 X 4 X 5 6 7 8 ✓ 4 End X X X

Loan payment Determine the equal, annual, end-of-year payment required each year over the life of the loan shown in the following table to repay it fully during the stated term of the loan. (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Principal $42,000 Interest rate 14% www The amount of the equal, annual, end-of-year payment, CF, is $ Term of loan (years) 20 (Round to the nearest cent.)

Calculate the principal portion of the second payment on the required on an amortized loan annual interest rate of 8.25% for 20 years. finance the purchase of a new home priced at $99,757.57 assuming the O A. $165.30 O B. $174.17 OC. $175.30 O D. $164.17 Click to select your answer. tUs /- MacBook Air 888 F4 14 F7 F1 F3 FS F6 II 4) F9 F10 F11 @ 2$ 4 23 & 2 6. 0. R Y P. S D F H. J K B alt command +

urgent please

Develop an amortization schedule for the loan described. (Round your answers to the nearest cent.) $130,000 for 3 years at 10% compounded annually Period Payment Interest Balance Reduction Unpaid Balance $130, 000 1 $ $ $ $2$$$$3$ $$ $0.00