User Account

All Pages

Constructing a spreadsheet that accounts for depreciation

Assignment Help Finance Basics
Reference no: EM133121717

(Objective: Constructing a spreadsheet that accounts for depreciation, amortization of loans, taxes and time value of money)

Construct a spreadsheet for the economic evaluation of the present worth of a project with the following characteristics:

The investment required is 20 million dollars. The positive cash flows start in the first year with 2 million, increasing by one million per year until being fixed at 8 million per year. The tax rate is 21% and the depreciation is MACRS-GDS for 5 years. The salvage value is negligible. The project capital requirements will be financed with a loan at 4% to finance 40% of the capital requirements. There are 8 yearly payments. The time value of money is 20%. Use a planning horizon of 20 years.

Reference no: EM133121717

Questions Cloud

Present value of 28 year cash flow : Ambrin Corp. expects to receive $6,000 per year for 14 years and $7,500 per year for the next 14 years. What is the present value of this 28 year cash flow?
What is the loan payment : The loan amount is for $18,155 with an annual interest rate of 12.00%. The loan will be repaid over 14 years with monthly payments.
What the net income attributable to noncontrolling interest : What was the net income attributable to the noncontrolling interest, assuming that the separate return method was used to assign the income tax expense
What are the key estimates used in capm : What are the key estimates used in CAPM? Why is this measure so harshly criticized? Do you agree with the critics? Why or why not?
Constructing a spreadsheet that accounts for depreciation : (Objective: Constructing a spreadsheet that accounts for depreciation, amortization of loans, taxes and time value of money)
What is the maximum price : Consider a 30-year bond that has a face value of $10,000 and a coupon rate of 9% with quarterly coupon payments. The yield to maturity (YTM) of the bond is 11%.
Net before-tax per share dollar return : If David uses these two options to form a collar, what will be his net before-tax per share dollar return if the stock price is $40.21 at expiration?
Calculate sally profit-loss : Sally decides to buy a Treasury note futures contract for delivery of $100,000 face amount in December, at a price of 110'3.5. At the same time, Scott decides t
What price change would lead to a margin call : What price change would lead to a margin call? Under what circumstances could $ 1,500$ be withdrawn from the margin account?

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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