This is an accounting project for my class. Can I please have the answers for each question and formulas? Not specific. Just the general formulas used for an annual payment, total interest payment, percentage of the total interest paid after 27 have been made. Thank you.
Use the following check digits:
Sum Total Cash flow = Sum interest paid
Owe at end = $0
Sum Principal repaid = amount borrowed
Sum Total Payment = Sum Interest paid + Sum principal repaid
IRR of the cash flows = interest rate
Balance | Interest | Repayment | B+I-R | Total Repayment Annually | |
8,64,000.00 | 1,02,816.00 | 1,02,924.11 | 8,63,891.89 | ||
8,63,891.89 | 1,02,803.13 | 1,02,924.11 | 8,63,770.91 | ||
8,63,770.91 | 1,02,788.74 | 1,02,924.11 | 8,63,635.53 | ||
8,63,635.53 | 1,02,772.63 | 1,02,924.11 | 8,63,484.04 | ||
8,63,484.04 | 1,02,754.60 | 1,02,924.11 | 8,63,314.53 | ||
8,63,314.53 | 1,02,734.43 | 1,02,924.11 | 8,63,124.85 | ||
8,63,124.85 | 1,02,711.86 | 1,02,924.11 | 8,62,912.59 | ||
8,62,912.59 | 1,02,686.60 | 1,02,924.11 | 8,62,675.07 | ||
8,62,675.07 | 1,02,658.33 | 1,02,924.11 | 8,62,409.29 | ||
8,62,409.29 | 1,02,626.71 | 1,02,924.11 | 8,62,111.89 | ||
8,62,111.89 | 1,02,591.31 | 1,02,924.11 | 8,61,779.09 | ||
8,61,779.09 | 1,02,551.71 | 1,02,924.11 | 8,61,406.68 | 12,35,089.37 | |
8,61,406.68 | 1,02,507.40 | 1,02,924.11 | 8,60,989.96 | ||
8,60,989.96 | 1,02,457.81 | 1,02,924.11 | 8,60,523.66 | ||
8,60,523.66 | 1,02,402.32 | 1,02,924.11 | 8,60,001.86 | ||
8,60,001.86 | 1,02,340.22 | 1,02,924.11 | 8,59,417.96 | ||
8,59,417.96 | 1,02,270.74 | 1,02,924.11 | 8,58,764.59 | ||
8,58,764.59 | 1,02,192.99 | 1,02,924.11 | 8,58,033.46 | ||
8,58,033.46 | 1,02,105.98 | 1,02,924.11 | 8,57,215.33 | ||
8,57,215.33 | 1,02,008.62 | 1,02,924.11 | 8,56,299.84 | ||
8,56,299.84 | 1,01,899.68 | 1,02,924.11 | 8,55,275.40 | ||
8,55,275.40 | 1,01,777.77 | 1,02,924.11 | 8,54,129.06 | ||
8,54,129.06 | 1,01,641.36 | 1,02,924.11 | 8,52,846.31 | ||
8,52,846.31 | 1,01,488.71 | 1,02,924.11 | 8,51,410.91 | 12,35,089.37 | |
8,51,410.91 | 1,01,317.90 | 1,02,924.11 | 8,49,804.69 | ||
8,49,804.69 | 1,01,126.76 | 1,02,924.11 | 8,48,007.33 | ||
8,48,007.33 | 1,00,912.87 | 1,02,924.11 | 8,45,996.09 | ||
8,45,996.09 | 1,00,673.53 | 1,02,924.11 | 8,43,745.51 | ||
8,43,745.51 | 1,00,405.72 | 1,02,924.11 | 8,41,227.12 | ||
8,41,227.12 | 1,00,106.03 | 1,02,924.11 | 8,38,409.03 | ||
8,38,409.03 | 99,770.67 | 1,02,924.11 | 8,35,255.59 | ||
8,35,255.59 | 99,395.41 | 1,02,924.11 | 8,31,726.89 | ||
8,31,726.89 | 98,975.50 | 1,02,924.11 | 8,27,778.27 | ||
8,27,778.27 | 98,505.61 | 1,02,924.11 | 8,23,359.78 | ||
8,23,359.78 | 97,979.81 | 1,02,924.11 | 8,18,415.47 | ||
8,18,415.47 | 97,391.44 | 1,02,924.11 | 8,12,882.80 | 12,35,089.37 | |
8,12,882.80 | 96,733.05 | 1,02,924.11 | 8,06,691.74 | ||
8,06,691.74 | 95,996.32 | 1,02,924.11 | 7,99,763.94 | ||
7,99,763.94 | 95,171.91 | 1,02,924.11 | 7,92,011.74 | ||
7,92,011.74 | 94,249.40 | 1,02,924.11 | 7,83,337.02 | ||
7,83,337.02 | 93,217.11 | 1,02,924.11 | 7,73,630.02 | ||
7,73,630.02 | 92,061.97 | 1,02,924.11 | 7,62,767.87 | ||
7,62,767.87 | 90,769.38 | 1,02,924.11 | 7,50,613.14 | ||
7,50,613.14 | 89,322.96 | 1,02,924.11 | 7,37,011.99 | ||
7,37,011.99 | 87,704.43 | 1,02,924.11 | 7,21,792.30 | ||
7,21,792.30 | 85,893.28 | 1,02,924.11 | 7,04,761.47 | ||
7,04,761.47 | 83,866.61 | 1,02,924.11 | 6,85,703.97 | ||
6,85,703.97 | 81,598.77 | 1,02,924.11 | 6,64,378.63 | 12,35,089.37 | |
6,64,378.63 | 79,061.06 | 1,02,924.11 | 6,40,515.57 | ||
6,40,515.57 | 76,221.35 | 1,02,924.11 | 6,13,812.81 | ||
6,13,812.81 | 73,043.72 | 1,02,924.11 | 5,83,932.42 | ||
5,83,932.42 | 69,487.96 | 1,02,924.11 | 5,50,496.26 | ||
5,50,496.26 | 65,509.05 | 1,02,924.11 | 5,13,081.20 | ||
5,13,081.20 | 61,056.66 | 1,02,924.11 | 4,71,213.75 | ||
4,71,213.75 | 56,074.44 | 1,02,924.11 | 4,24,364.07 | ||
4,24,364.07 | 50,499.32 | 1,02,924.11 | 3,71,939.28 | ||
3,71,939.28 | 44,260.77 | 1,02,924.11 | 3,13,275.94 | ||
3,13,275.94 | 37,279.84 | 1,02,924.11 | 2,47,631.67 | ||
2,47,631.67 | 29,468.17 | 1,02,924.11 | 1,74,175.72 | ||
1,74,175.72 | 20,726.91 | 1,02,924.11 | 91,978.52 | 12,35,089.37 | |
91,978.52 | 10,945.44 | 1,02,924.11 | (0.15) | 1,02,924.11 | |
Repayment PAID | 62,78,370.95 | ||||
Total Principal | 8,64,000.00 | ||||
(102924.11*27-2660034.30) | After 27Month Total Principal | 1,18,916.78 | |||
(118916.78/864000*100) | How Much % Paid | 13.76% | |||
Total Intt Paid | 54,14,370.80 | ||||
After 27 Intt | 26,60,034.30 | 49.13% |
Balance | Interest | Repayment | B+I-R | Total Repayment Annually | |
8,64,000.00 | 17,280.00 | 24,643.69 | 8,56,636.32 | ||
8,56,636.32 | 17,132.73 | 24,643.69 | 8,49,125.36 | ||
8,49,125.36 | 16,982.51 | 24,643.69 | 8,41,464.18 | ||
8,41,464.18 | 16,829.28 | 24,643.69 | 8,33,649.78 | ||
8,33,649.78 | 16,673.00 | 24,643.69 | 8,25,679.09 | ||
Repayment PAID | 15,03,264.79 | ||||
Total Principal | 8,63,999.94 | ||||
After 27Month Total Principal | 2,72,585.63 | ||||
How Much % Paid | 31.55% | ||||
Total Intt Paid | 6,39,264.70 | ||||
After 27 Intt | 3,92,793.87 | 61.44% | |||
This is an accounting project for my class. Can I please have the answers for each question and formulas? Not specific. Just the general formulas used for an annual payment, total interest payment, pe...
You borrow money on a self liquidating installemnt loan (equal payments at the end of each year, each payment is part principal part interest) Loan Interest Rate Life (years) Date of Loan $902,000 12.80% 49 January 1, 2019 Use the installment method-not straight line Do NOT round any interrmediate numbers. Do NOT turn this into a monthly problem. a) What is the annual payment? b) What are the total interest payments? c) After 29 payments have been made, what percentage...
Please include excel formulas/steps/directions for each part and where I should input the formulas. Don't just give the answers. It'd probably be best if you post your own spreadsheet for reference as well, with formulas included. I need a well designed spreadsheet. Thank you! 2 3 You borrow money on a self liquidating installent loan (equal payments at the end of each year, each payment is part principal part interest) Loan $137,000 Interest Rate 10.40% Life (years) Date of Loan...
Accounting Question $943,000 Loan Interest Rate Life (years) Date of Loan 43 Use the installment method - not straight line Do NOT round any interrmediate numbers. Do NOT turn this into a monthly problem. a) What is the annual payment? b) What are the total interest payments? c) After 17 payments have been made, what percentage of the total interest has been paid (round to the nearest percentage point)? d) After 17 payments have been made, what percentage of the...
2 You borrow money on a self liquidating installemnt loan (equal payments at the end of each year, each payment is part principal part interest) 3 Loan 4 Interest Rate 5 Life (years) 6 Date of Loan $292,000 15.30% 42 January 1, 2018 9 Use the installment method not straight line 10 Do NOT round any interrmediate numbers 11 Do NOT turn this into a monthly problem. 12 13 a) What is the annual payment? 14 b What are the...
please Help! You borrow money on a self liquidating installement loan (equal payments at the end of each year, each payment is part principal part interest) I also need the excel formulas . Please do it on excel. You bomow money on a self liquidating instalent loan (equal payments at the end of each year, each payment is part principal part interest Loan $312,000 Interest Rate 13 30% Life years) Date of Loan January 1, 2020 Use the installment method...
2. For the following annuity due, determine the nominal annual rate of interest. Future Value Term Present Value Periodic Rent Payment Period Conversion Period monthly $2,581 $540 1 year 4 years %. The nominal annual rate of interest is (Round to two decimal places as needed.) 3. A company borrowed $13,000 paying interest at 8% compounded quarterly. If the loan is repaid by payments of $1800 made at the end of each 3 months, construct a partial amortization schedule showing...
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...
An amount of $15,000 is borrowed from the bank at an annual interest rate 12% h Calculate the repavment amounts if the loan ($15 000) will be repaid in two equal installments of $7.500 each, paid at the end of second and fourth years respectively. Interest will be paid each year Click the icon to view the interest and annuity table for discrete compounding when i- 12%% per year . a. The equal end-of-year payments required to pay off the...
i dont think those answers are correct and i am trying to find the total interest Question 5 (of 35) Save & Exit Submit Time remaining: 2.51:03 8.00 points Problem 5-55 Amortization with Equal Payments (LO 3] Prepare an amortization schedule for a three year loan of $81,00). The interest rate is 8 percent per year, and the loan cals for equal annual payments. How much total interest is paid over the life of the loan? (Leave no cells blank....
QUESTION 5 What is the principal (to the nearest whole dollar) remaining after 24 monthly payments have been made on a $55,000 five-year loan? The annual interest rate is 3% nominal compounded monthly. (Do not enter a dollar sign $ with your answer.) QUESTION 5 What is the principal (to the nearest whole dollar) remaining after 24 monthly payments have been made on a $55,000 five-year loan? The annual interest rate is 3% nominal compounded monthly. (Do not enter a...