Question: With excell formulas please You borrow money on a self liquidating installemnt loan (equal payments at the end of each year, each payment is part

With excell formulas please

With excell formulas please You borrow money on a self liquidating installemnt

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 $197,000 4 Interest Rate 16.00% 5 Life (years) 6 Date of Loan January 1, 2020 9 Use the installment method - not straight line 10 DO NOT round any interrmediate numbers. 11 Do NOT turn this into a monthly problem. 13 a) What is the annual payment? 14b) What are the total interest payments? 15 C) After 29 payments have been made, what percentage of the total interest has been paid (round to the nearest percentage point)? 16 d) After 29 payments have been made, what percentage of the total principal has been paid (round to the nearest percentage point)? 17 18 Redo the problem if the interest rate is 2.00% 20 (for a well designed spreadsheet this should take 30 seconds) 23 22 e) What is the annual payment? 1) What are the total interest payments? 24 g) After 29 payments have been made, what percentage of the total interest has been paid (round to the nearest percentage point)? 25 h) After 29 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!

Consider a diffusion couple between silver and a gold alloy that contains 10 wt% silver. This couple is heat treated at an elevated temperature and it was found that after 850 s the concentration of...

What are the excel forumals I should put in to find Questions A,B,C,D? Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) = = = ab 11 LI % 8 O Conditional...

Please show how to make the spreadsheet and please leave answer C,D,G,H in PERCENTAGE format. Loan Problem Instructions: Follow these instructions carefully . You dont want to lose points for not...

can you please email me the answer with an excel sheet over homework.baruch at google mail period com Loan Problem Instructions: Follow these instructions carefully . You dont want to lose points for...

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 You...

need answer in excel Use the following check digits: Sum Total Cash flow = Sum interest paid Owe at end = $0 2 You borrow money on a self liquidating installemnt loan (equal payments at the end of...

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 $438,000 Interest Rate 16.70% Life (years) Date of...

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 $882,000 Interest Rate 10.00% Life (years) 47 Date...

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 $939,000 Interest Rate 11.00% Life (years) 62 Date...

You Borrow money on a self liquidating installemnt loan (equal payments at the end of each year, each payment is part principal part interest) Could someone verify my answers? These are the answers I...

You Borrow money on a self liquidating installemnt loan (equal payments at the end of each year, each payment is part principal part interest) You borrow money on a self liquidating installemnt loan...

If two disks A and B have the same mass and are subjected to direct central impact such that the collision is perfectly elastic (e = 1), prove that the kinetic energy before collision equals the...

Read and respond to the following description: When referring to psychology, a critical period is defined as a maturational stage in the lifespan of an organism during which the nervous system is...

4 a Copy and complete the tables for these function machines. b Write each function in part a as an equation. i iii y 10 15- 15 +5 4 9 11 D 100 3 .x y 0 ii 30 100 4 +6 x 12 39 y 5 12 iv k +8 x2 112 2...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

=+2 Determine the specific cross-cultural training needs (from the organization level, assignment level, and the individual level).

=+j How will the MNE assess the differing content (skills and knowledge) that each locale requires?

=+3 Establish the goals and measures for determining training effectiveness.