Sensitivity analysis and break-even point

Assignment Help Finance Basics
Reference no: EM132345662

Could you please help to answer the below question and show how this could be determined in excel as well?

Sensitivity Analysis and Break-Even Point. We are evaluating a project that costs $604,000, has an 8 year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 55,000 units per year. Price per unit is $36, variable cost per unit is $17, and fixed costs are $685,000 per year. The tax rate is 21 percent and we require a return of 15 percent on this project.

a) Calculate the accounting break-even point.

b) Calculate the base-case cash flow and NPV. What is the sensitivity of NPV to changes in the sales figure? Explain what your answer tells you about a 500-unit decrease in projected sales.

c) What is the sensitivity of OCF to changes in the variable cost figure? Explain what your answer tells you about a $1 decrease in estimated variable costs.

Reference no: EM132345662

Questions Cloud

What is the firm cost of preferred stock : The firm's marginal tax rate is 40%. What is the firm's cost of preferred stock?
Prepare the entry for the issuance under the following : The stock had a par value of $4 per share and was issued to attorneys for services during incorporation valued at $51,000.Prepare the entry for the issuance.
Prepare journal entries for the given petty cash fund : Established a $75 petty cash fund. Increased the petty cash fund to $100. Replenished the petty cash fund. Currency and coins remaining were $20.
Estimate the beta of a stock : In the regression, the X variable is the historical stock return and the Y variable is the historical stock index return.
Sensitivity analysis and break-even point : Sensitivity Analysis and Break-Even Point. We are evaluating a project that costs $604,000, has an 8 year life, and has no salvage value.
Calculating salvage value : An asset used in a 4 year project falls in the 5 year MACRS class for tax purposes. The asset has an acquisition cost of $7.6 million and will be sold
Calculating project npv : Could you please help me to determine the answer to below and show also how this could be determined in excel?
Calculating profitability index : Calculating Profitability Index. Bill plans to open a self-serve grooming center in a storefront. The grooming equipment will cost $325,000
Calculate the expected return and standard deviation : Based on historical data, you have estimated the following probability distributions for the returns on two individual securities

Reviews

Write a Review

Finance Basics Questions & Answers

  What was the apr

He paid it all back at once on December 31, 2017. What was the APR? (Enter your answer as a percent rounded to 1 decimal place.)

  Opinion polls attempt to predict the results of local

opinion polls attempt to predict the results of local state and federal elections. discuss six reasons why the results

  How much must you repay him to pay off the loan

Mr. Miser loans money at an annual rate of 73 percent compounded daily. You decide to borrow $10,000 from him and must repay the full principal and interest at the end of 2 years. How much must you repay him to pay off the loan?

  What is the cash conversion cycle

Discuss the impact of things like just-in-time inventory systems and point of sales systems on the need for cash. For instance, look at the days payable, days inventory and AR days for your company. What is the cash conversion cycle?

  Calculate the cost of capital for the individual components

Calculate the cost of capital for the individual components in the capital structure, and then calculate the weighted average cost of capital for Seabreeze. Consider after-tax cost of capital in your calculations.

  Find the 95 confidence interval of the population mean age

in a study of 10 insurance sales representatives from a certain large city the average age of the group was 48.6 years

  What is the theoretical and practical trade-off

What is the theoretical and practical trade-off when measuring the pension liability using the projected benefit obligation compared to the accumulated benefit obligation?

  Journal entry to record the stock issuance

A company issues 2,000 shares of common stock for $ 32,000. The stock has a stated value of $10 per share. The journal entry to record the stock issuance would include a credit to Common Stock for.

  What are the zero coupon bond prices with face values

What are the zero coupon bond prices with face values of $100 and maturities 0.5, 1, 1.5, and 2 years respectively

  Net present value (npv)

Elaborate on why the net present value (NPV) of a relatively long-term project is more sensitive to changes in the cost of capital than is the NPV of a short-term project. Provide two good examples of NPV that support your position.

  Process and purpose of budget analysis

1. Explain in detail 'Incremental Budgeting' and 'Zero based Budgeting' and Combination of these two.

  Number of pages with moderate and high graphics

A sample of four pages is selected without replacement, and X and Y denote the number of pages with moderate and high graphics output in the sample. Determine fXY (x; y), fX(x), E(X), fY j3(y) and E(Y jX = 3). Are X and Y independent?

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