Question regarding the loan amortization

Assignment Help HR Management

Reference no: EM13748280

Can you please show me how to do this in ms Excel. Find the payment you would need to make per year at a discount rate (interest rate that the bank charges you) from 0% to 50% (51 answers), if you borrow $5,000,000 ($5 million) today (PV) and pay it back in equal amounts over the next 30 years. Make a table and graph of your answers.

Additional Requirements

Min Pages: 1

Level of Detail: Show all work

Reference no: EM13748280

Questions Cloud

What did federalists believe threatened nation in election : What did the Federalists believe threatened the nation in the election of 1800?

A comparison to the legacies of cultural syncretism : A comparison to the legacies of cultural syncretism. Cultural Factors That Caused the Differences In Outcomes. The Legacies That the Differences In Types of Encounters and Degrees of Cultural Change Have Left Today

Catherine ii launched a campaign aimed at expanding foreign : After crushing the challenges to her rule, Catherine II launched a campaign aimed at expanding foreign and especially Western European influence in an ongoing effort to modernize.

Materials needed for electrostatic sprayer : Know the materials needed for electrostatic sprayer

Question regarding the loan amortization : Can you please show me how to do this in ms Excel. Find the payment you would need to make per year at a discount rate (interest rate that the bank charges you) from 0% to 50% (51 answers), if you borrow $5,000,000 ($5 million) today (PV) and pay ..

Determine the flow rate of oil through : During the flow, the pressure at the pipe inlet and exit is measured to be 8.25 bar and 0.97 bar, respectively and determine the flow rate of oil through the pipe assuming the pipe is horizontal.

Initial cash flow and each year cash flow : The machine is expected to save $35000, $45000 and $55000 in year 1,2and 3, respectively. If lion lighting has a 30% marginal tax rate, what are the initial cash flow and each year's cash flow from the project?

Least three differences between the two companies : Did you submit the assignments on time. Did you list at least three differences between the two companies

Level budgeting for construction projects : An integer programming model would be utilized in scheduling for high demand space in government buildings or classrooms or it can be used in high level budgeting for construction projects.

User Account

All Pages