User Account

All Pages

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

  Which break-even sales level is usually lower

For the same project, which break-even sales level is usually lower, the net present value breakeven or the income breakeven? Pick one

  What is the length of the firm''s cash conversion cycle

What is the length of the firm's cash conversion cycle and What would happen to Saliford's cash conversion cycle if, on average, the length of time that products remain in inventory is shortened to 45 days?

  Creamy custard common stock is currently selling for 7900

creamy custard common stock is currently selling for 79.00. it just paid a dividend of 4.60 and dividends are expected

  Baxter video productss sales are expected to increase by 20

baxter video productss sales are expected to increase by 20 from 5 million in 2010 to 6 million in 2011. its assets

  Compute the future values of the ordinary annuities fv of

find the future values of the following ordinary annuitiesa. fv of 400 each 6 months for 5 years at a nominal rate of

  From the following information calculate i current ratio ii

from the following information calculate i current ratio ii quick ratio and iii working capital turnover

  What single investment made today

What single investment made today, earning 12% annual interest, will be worth $6,000 at the end of six years?

  Mergers and acquisition-sample question

Describe your views on mergers and acquisitions (M&As). Analyze the related issues and implications both from perspective of managers and investors.

  Describe and discuss the concept of ethics

Describe and discuss the concept of ethics, please give an example.

  You are interested in a bond it has a 11 year remaining

you are interested in a bond. it has a 11 year remaining and a 6.25 coupon rate. the price is quoted at 100. what is

  Warrants are considered to highly speculative because when

1. when should an investor calculate both yield to maturity and yield to call?a. whenever there is a call provisionb.

  What is the value of teldar to gekko properties

Teldar's post-merger beta is estimated to be 1.7, and its post-merger tax rate would be 35%. The risk-free rate is 6%, and the market risk premium is 5.5%. What is the value of Teldar to Gekko Properties?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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