Create monthly amortization schedule for fixed rate

Assignment Help Financial Management

Reference no: EM131873661

Using the headers in tab A4 of the Excel spreadsheet and the input values included in the green “box”: a. Create a monthly amortization schedule for a fixed rate 15-year mortgage. Make sure that any value that the user (me in this case) changes in the green “box” will be reflected in your amortization schedule. Your monthly payment calculation should be included in cell J5 and should also automatically change with any changes to the values in the green “box”. b. Next to the amortization schedule, create an Excel graph that shows the remaining mortgage balance overtime. Make sure that your graph is labeled appropriately. c. Include a vlookup function in cell L7 that will reflect the remaining mortgage balance associated with the end of the month entered by the user into cell J7. For example, if the user enters 34 into cell J7, cell L7 will automatically show the remaining mortgage balance after 34 months.

Reference no: EM131873661

Questions Cloud

Normal method of communication nowadays : With the technology advances in the past decade, the use of cell phones have become a normal method of communication nowadays.

Why recruiting is an important factor in a successful sales : Recommend ways to keep the team motivated and explain why these methods of motivation might work.

How should premiere record the details of the equipment : Premiere discarded the equipment, even though its book value was $11,250. How should Premiere record the details of the equipment disposal

What type of patient is typically impact by the given issue : What type of patient is typically impacted by this issue? What nursing departments or internal departments are impacted by this issue?

Create monthly amortization schedule for fixed rate : Create a monthly amortization schedule for a fixed rate 15-year mortgage.

What is the correct cost to be included : Miller Machinery recently made some improvements to their facility. What is the correct cost to be included in the Land Improvements account

Explain the rationale for government regulations on business : Explain the rationale for government regulations on businesses in your own words.Identify a federal or state regulation that you support or oppose.

What is the depletion cost per barrel : What is the depletion cost per barrel if a newly discovered oil well costs $6 million to acquire, drilling permits cost $525,000

Research and explain the purpose of the agency : Identify one agency, bureau or department within the federal government responsible for upholding regulations that impact business operations.

User Account

All Pages