Question: I need help to make Microsoft Excel spreadsheet that will generate an amortization table for loans. The table should be able to model 360 payments

I need help to make Microsoft Excel spreadsheet that will generate an amortization table for loans. The table should be able to model 360 payments (30 year mortgage). The user should be able to input: initial loan amount, the APR, and number of monthly payments for the period of the loan. Columns in the table should include the month, the amount of interest, the principal payment, and the ending balance. Additional principal payments such as $100.00 per payment period should be able to be considered as an input from the user.

An example is included.

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!

I need help to make Microsoft Excel spreadsheet that will generate an amortization table for loans. The table should be able to model 360 payments (30 year mortgage). The user should be able to...

create a Microsoft Excel spreadsheet that will generate an amortization table for loans. The table should be able to model up to 360 payments (30 year mortgage). The user should be able to input the...

For this assignment, create a Microsoft Excel spreadsheet that will generate an amortization table for loans. The table should be able to model up to 360 payments (30 year mortgage). The user should...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

Hello, Need help with the following:Please see Rubric thks Using information from"Are You Paying Too Much for That Acquisition?" List and describe the components used to calculate synergy value....

Spreadsheet project 1 Loans Professor John purchased a house on September 1, 2003. The house cost $184,000. He made a down payment of $40,000 and borrowed the rest in the form of a mortgage (real...

This exercise is comprised of four parts. Part 1 covers automated routines macros in Excel to rearrange and transform data, Part 2 covers Pivot Table: Data Sets Cross-Tabulation and Querying in Excel...

Explain what you understand by blockchain and text timing . Give 2 examples each. How are they useful in the Accounting or Auditing system?

how would you alter the table structure? What data redundancies do you detect? Give example of how could those redundancies lead to data anomalies? How many records does the table contain? How many...

The first section heading is: RESULTS OF OPERATIONS Under this heading, include a common - size table following the format reviewed in the Buckle, Inc. annual report in Unit 8 . Following this table,...

The Everly Equipment Company's flange-lipping machine waspurchased 5 years ago for $70,000. It had an expected life of 10years when it was bought and its remaining depreciation is $7,000per year fo 2...