Question: Many parts have been already done please solve using excel Question 3 of 9 Amy received a loan of $35,000 at 5.25% compounded monthly. He

Many parts have been already done please solve using excel Question

3 of 9 Amy received a loan of $35,000 at 5.25% compounded

monthly. He had to make payments at the end of every month

for a period of 5 years to settle the loan. a. Calculate

Many parts have been already done please solve using excel

Question 3 of 9 Amy received a loan of $35,000 at 5.25% compounded monthly. He had to make payments at the end of every month for a period of 5 years to settle the loan. a. Calculate the size of payments. 664.51 Round to the nearest cent Question 3 of 9 b. Fill in the partial amortization schedule for the loan, rounding your answers to two decimal places. Payment Interest Portion Payment Number Principal Portion Principal Balance $35,000.00 0 Question 3 of 9 $664.51 $153.13 $511.38 $34,488.62 1 1 $664.51 S150.89 $513.62 $33,975.00 2 ha Question 3 of 9 59 $664.51 $20.97 $641.30 $0.00 X X x 60 $664.51 $0.00 $0.00 0.00 (x x $39,870.60 $0.00 0 Total x

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 Finance Questions!

1. The following topographic map (Map 3.1) is from a coastal area and features an interesting geological hazard in addition to the Ocean. Using a contour interval of 4o meters, label the elevation of...

Sofia is 45 years old. She has 3 children, Meg age 12, Jo age 14 and Amy age 15. However, she is already planning for retirement. She plans on retiring in 15 years when she will be 60 years old....

please help me. I can pay only 70 dollars in this assignment Topic 1 & 2 Introduction to financial management and the Australian Taxation system Financial Markets 2 Learning Objectives Describe what...

JUST ANSWER THE FIRST PAGE: ALL INFO ARE ALREADY GIVEN PRESENT VALUE OF SIMPLE ANNUITY DUE EXAMPLE: Hope borrows money for the renovation of her house and repays by making yearly payments of P50,...

TO BE ANSWERED: All of theinfos are already given below just answer the first photo PRESENT VALUE OF SIMPLE ANNUITY DUE EXAMPLE: Hope borrows money for the renovation of her house and repays by...

please help me in 70 dollars to do this assignment iin APA style referencing Topic 1 & 2 Introduction to financial management and the Australian Taxation system Financial Markets 2 Learning...

Need help figuring out problem #40, #42, and #45 in the attached document. I have the answers for the problems, but need to see how they are worked out. FIN 142 - Real Estate Finance Problem Set 2 1....

Please work using excel spreadsheet, and providing functions for review. Please and thank you, can you provide this quickly, greatly appreciate it. **The problems have already been worked, just need...

need this done in 2hrs...multiple choice..see attached QUESTION 1 The tax rate that determines the amount of tax that will be due on the next dollar of taxable income earned is called the: 1. average...

Assignment Problems 1. On the day Saffron was born, her parents put $36,000 into an investment account that promises to pay a fixed interest rate of 11 percent per year. How much money willshe have...

1. Overall, what is the overlap between Network Solutions' system and an ideal system? 2. What are the features of the system implemented at Network Solutions that correspond to the features...

On January 1, 2011, Timothy Company purchased Macys Company at a price of $3,750,000. The fair market value of the net assets purchased equals $2,700,000. 1. What is the amount of goodwill that...

Indigo Architects Ltd . is a private company reporting under ASPE. It is authorized to issue an unlimited number of common and $ 3 cumulative preferred shares. The following is an alphabetical list...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...