Prepare loan amortization schedule based on monthlypayments

Assignment Help Financial Management
Reference no: EM131175074

Assignment:

Based on the information provided below, compute the Net Present Value of the project. A Net Present Value Template is Attached. (Hint: Don't forget to update the discount rate to the amount required for this project and add your cash flow numbers.)

Royal Dutch Shipping is planning on Investing $1,600,000 to buy a freighter. Prepare a net present value analysis based on the assumption that the freighter will be sold for 10% of its cost at the end of the year 5. Assume a 10% cost of capital. Annual operating cash flows for the project are:

Year 1: $380,000
Year 2: $390,000
Year 3: $400,000
Year 4: $410,000
Year 5: $420,000

Prepare a loan amortization schedule based on monthlypayments for the $1,600,000 if Royal Dutch Shipping can pay 10% down on a loan for $1,600,000 and can get a loan for 6% interest for 10 years (do not include this in your Net Present Value computations. This is a separate issue. 

(Hint:www.bankrate.com/calculators/mortgages/amortization-calculator.aspx )

Reference no: EM131175074

Questions Cloud

Will the buyer succeed in recovering the excess : A shipbuilder had contracted to build a tanker for North Ocean Tankers.- Will the buyer succeed in recovering the excess?
How professional etiquette impacts workplace relationships : Do you think executive compensation in its various parts (i.e., salary, stock options, severance packages) funded at the current levels is unethical? If so, how would you revise the compensation so that it was just? On what basis would you change ..
Marketing process to a product : Conduct a market research, demonstrating how you would apply the marketing process to a product using the concepts in the 5Cs, STP and the 4Ps
Discuss your calculated share price : Discuss your calculated Share price, How confident are you in the analysis? How might you address any concerns affect your confidence level
Prepare loan amortization schedule based on monthlypayments : Based on the information provided below, compute the Net Present Value of the project.- Prepare loan amortization schedule based on monthlypayments.
Describe education opportunities that could enhance career : Write a 2 - 3 content page paper describing some continuing education opportunities that could enhance your career. Cite specific examples. Be sure to provide appropriate references and citations.
Calculate the present value and future value : Given that other investments of equal risk earn 10% per annum, calculate the present value and future value of this investment.
Describe the benefits of the change to the organization : Describe the benefits of the change to the organization. Identify key stakeholders that will be affected by this change. Discuss how your solution upholds ethical standards, or explain if there any possible ethical dilemmas that could surface.
Calculate the amount for the regular installments : Calculate the expected return on each share. - Calculate the variance and standard deviation for each share.- calculate the amount for the regular installments?

Reviews

Write a Review

Financial Management Questions & Answers

  What rate of return would they be earning

Your folks just called and would like some advice from you. An insurance agent just called them and offered them the opportunity to purchase an annuity for $22,691.00 that will pay them $3,500 per year for 10 years. They don’t have the slightest idea..

  Please show formulasa balance sheet shows a total of

please show formulas.a balance sheet shows a total of noncallable 45 million. long-termdebt with a coupon rate of 7.00

  When should a firm consider the portfolio effects of project

When should a firm consider the portfolio effects of a new project? What are the primary advantages and disadvantages of applying simulation to capital budgeting risk analysis?

  What would be the total system costs

Assume the firm changed to a continuous review system to control the item depicted in Table 5. What would be the total (annual) Q system costs?

  Short term debt creditors and equity investors

List the thing that short term debt creditors and Equity investors are interested in seeing in a company's financial statement

  What is the firms earnings growth rate

The newspaper reported last week that Bennington Enterprises earned $34 million this year. The report also stated that the firm’s return on equity is 16 percent. Bennington retains 80 percent of its earnings. What is the firm's earnings growth rate? ..

  What is the sharpe ratio for stock

A- Investments B and C both have the same standard deviation of 20% and have the same correlation to the market portfolio. If the expected return on B is 15% and the expected return on C is 18%, which investment would investors prefer? B- The market ..

  What are the initial costs at closing

You purchase a new house for $200,000 with a 5% down payment. You obtain a 30-year loan at 5% compounded monthly and will make monthly payments on the loan. Closing costs are $1,500. PMI is $150 per month for the first 5 years. Taxes are estimated to..

  Draw cash flow diagram from the companys perspective

A manufacturing company invests $100,000 in a new piece of equipment. Operating expenses for this new piece of equipment is estimated to be $4,000 starting EOY1 and increasing by $200 per year at the EOY2 and for the next 9 additional years. Draw a c..

  Accumulated in the account if the interest rate applied

A person increases the amount of money he invests $10 per month. He invests $100 on the first month and makes a total 24 payments. How much will be accumulated in the account if the interest rate applied was 6% simple and compounded monthly?

  What stock price would you consider appropriate

The Perfect Rose Co. has earnings of $1.85 per share. The benchmark PE for the company is 15. What stock price would you consider appropriate? What if the benchmark PE were 18?

  What variables must be known in applying the capitalization

What variables must be known (or estimated) in applying the capitalization of cash flow method of valuation to a physical or financial asset?

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