Question: Please answer correctly, I will be giving thumbs up. You borrow money on a self liquidating installment loan (equal payments at the end of each

Please answer correctly, I will be giving thumbs up.Please answer correctly, I will be giving thumbs up. You borrow moneyon a self liquidating installment loan (equal payments at the end of

You borrow money on a self liquidating installment loan (equal payments at the end of each year, each payment is part principal part interest) Loan amount $442,000 Interest Rate 13.2% Life 161 51 years Date of Loan January 1, 2021 Use the installment method - not straight line Do NOT round any interrmediate numbers. Do NOT turn this into a monthly problem. Do NOT put in minus signs, answer all positive numbers. Required: 1. What is the annual payment (round to the nearest $)? 2. What are the total interest payments (round to the nearest $)? $ 3. After 37 payments have been made, what percentage of the total interest has been paid (round to the nearest percentage point)? % 4. After 37 payments have been made, what percentage of the total principal has been paid (round to the nearest percentage point)? % Redo the problem if the interest rate is 1% (for a well designed spreadsheet this should take 30 seconds) Required: 5. What is the annual payment (round to the nearest $)? 6. What are the total interest payments (round to the nearest $)? 7. After 37 payments have been made, what percentage of the total interest has been paid (round to the nearest percentage point)? % 8. After 37 payments have been made, what percentage of the total principal has been paid (round to the nearest percentage point)? % You borrow money on a self liquidating installment loan (equal payments at the end of each year, each payment is part principal part interest) Loan amount $442,000 Interest Rate 13.2% Life 161 51 years Date of Loan January 1, 2021 Use the installment method - not straight line Do NOT round any interrmediate numbers. Do NOT turn this into a monthly problem. Do NOT put in minus signs, answer all positive numbers. Required: 1. What is the annual payment (round to the nearest $)? 2. What are the total interest payments (round to the nearest $)? $ 3. After 37 payments have been made, what percentage of the total interest has been paid (round to the nearest percentage point)? % 4. After 37 payments have been made, what percentage of the total principal has been paid (round to the nearest percentage point)? % Redo the problem if the interest rate is 1% (for a well designed spreadsheet this should take 30 seconds) Required: 5. What is the annual payment (round to the nearest $)? 6. What are the total interest payments (round to the nearest $)? 7. After 37 payments have been made, what percentage of the total interest has been paid (round to the nearest percentage point)? % 8. After 37 payments have been made, what percentage of the total principal has been paid (round to the nearest percentage point)? %

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!