Find the payment

Assignment Help Finance Basics
Reference no: EM13742648

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.

Reference no: EM13742648

Questions Cloud

Calculate the monthly mortgage payment of principal : Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity. Use Excel to develop this response and present your result within a..
Write an hypothesis and prediction about water sample : Write an hypothesis and prediction about your water sample: Hypothesis: The water that we drink everyday is completly clean, we would not fin any type of bacteria or chemical in the water we are testing
Write a synopsis of material found on united nations site : You must write a brief synopsis of the material found on United Nations site. Each synopsis must include the full citation of the website using MLA standards for bibliographies.
Prepare case study on organizational behavior management : Prepare case study on Organizational Behavior Management
Find the payment : 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 ..
Do you agree with robert hughes critique : You have learned about Robert Hughes' concerns regarding the skyrocketing prices of art. Do you agree with his critique? What are some other consequences of such astronomical pricing?
Initial cash flow and year cash flow : If lion lighting has a 30% marginal tax rate, what are the initial cash flow and each year's cash flow from the project?
How structure relates to function in dna or in rna : Please provide an example of how structure relates to function in DNA or in RNA. There are many possibilities there and Describe operons and their contribution to homeostasis. Or, describe another way genes are regulated
What are franchise agreements : Summarize the following acts: sections 1 and 2 of the Sherman Act; the Clayton Act and the relationship to mergers; and the Robinson-Patman Act on price discrimination. What are franchise agreements?

Reviews

Write a Review

Finance Basics Questions & Answers

  The dollar-euro exchange rate is 125 euro100 and the

the dollar-euro exchange rate is 1.25 euro1.00 and the dollar-yen exchange rate is yen100 1.00. what is the euro-yen

  If the firm has 100 shares of common stock outstanding a

the smythe corporations common stock is currently selling at 100 per share which represents a pe ratio of 10. if the

  Objective question related to finance

If you invest $750 every six months at 8 percent compounded semi-annually, how much would you accumulate at the end of 10-years?

  Identify five qualitative financial and economic assessments

Identify five qualitative financial and economic assessments specific to Gant and its industry that you shouldconsider in further analyzing Gant's liquidity.

  What is the retained earnings balance at the end of the year

Ring Station Company began business on January 1 and immediately issued 500,000 shares of its $1 par value common stock for $8,000,000. At the end of the year it paid $400,000 in cash dividends.

  Discuss the moral and economic implications involved in the

discuss the moral and economic implications involved in the occupy wall street

  Explain how much external financing will the firm have to

axle supply co. expects sales next year to be 300000. inventory and accounts receivable will increase by 60000 to

  Describe how the reporting of extraordinary items is

Describe how the reporting of extraordinary items is a good example of the shift away from finite uniformity to rigid uniformity in accounting standards.

  Determine the most important five skills that a forensic

using the wileyplus resources go to the ldquoforensic accountants fraud bustersrdquo example. nbsp1.determine the most

  Which unit would you recommend

If the WACC rose to 15% would this affect your recommendation ? EXplain your answer and the reason this result occurred.

  Calculating profitability index what is the profitability

calculating profitability index what is the profitability index for the following set of cash flows if the relevant

  Supernormal and negative growth

Finley Corporation is increasing quickly. Dividends are expected to increase at 25% rate for the next three years, with a growth rate falling off to a constant 6% thereafter

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd