Question

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.

23542219 PROBLEM # 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 $864,000 11.90% 61 January 1, 2019 Use the installment method-not straight line Do NOT round any interrmediate numbers Do NOTturn this into a monthly problenm a) What is the annual payment? b) What are the total interest paymen c) After 27 payments have been made, what percentage of thetotal interest has been paid (round to the nearest percentage point)? d) After 27 payments have been made, what percentage of the total principal has been paid (round to the nearest percentage point)? ents? Redo the problem if the interest rate is 2.00% (for a well designed spreadsheet this should take 30 seconds) e) What is the annual payment? f) What are the total interest payments? g) After 27 payments have been made, what percentage ofthe total interest has been paid (round to the nearest percentage point)? h) After 27 payments have been made, what percentage of the total principal has been paid (round to the nearest percentage point)?

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

Answer 1

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%