I always rate! Show Excel work, please You have been asked to perform scenario analysis, sensitivity...

I always rate! Show Excel work, please

You have been asked to perform scenario analysis, sensitivity analysis, and break even analysis for producing a new golf ball. These new golf balls will sell from $2 a piece. In the best case scenario you think you will sell 750,000 balls, in the most likely case you will sell 500,000 balls and in the worst case you will sell 300,00 balls. Your variable cost is 35% and you have $300,000 in fixed costs. Your depreciation will be $100,000 and you have a 25% tax rate.

How sensitive are you to your variable cost? Create a data table ranging from 30% to 45% variable cost rate for the most likely case to show how changes in variable costs effect your net income.

Solutions

Expert Solution

jeff jeffy answered 6 days ago

Next > < Previous

Related Solutions

question 2 - please show your work in excel or paper. You have been hired by...

question 2 - please show your work in excel or paper. You have been hired by the CFO of Lugones Industries to help estimate its cost of common equity. You have obtained the following data: (1) rd = yield on the firm’s bonds = 7.00% and the risk premium over its own debt cost = 4.00%. (2) rRF = 5.00%, Market Risk Premium = 6.00%, and β = 1.25. (3) D1 = $1.20, P0 = $35.00, and g = 8.00%...

Please show all work!! You have been asked by the president of your company to evaluate...

Please show all work!! You have been asked by the president of your company to evaluate the proposed acquisition of a new spectrometer for the firm’s R&D department. The equipment’s basic price is $70,000 and it would cost another $15,000 to modify it for special use by your firm. The spectrometer, which has a MACRS 3-year recovery period, would be sold after 3 years for $30,000. Use of the equipment would require an increase in net working capital (spare parts...

Show work (excel if possible but show formulas you used in excel): If I buy a...

Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?

Show work (excel if possible but show formulas you used in excel): If I buy a...

Scenario: You work for an investment banking firm and have been asked by management of Vestor...

Scenario: You work for an investment banking firm and have been asked by management of Vestor Corporation (not real), a software development company, to calculate its weighted average cost of capital, to use in evaluating a new company investment. The firm is considering a new investment in a warehousing facility, which it believes will generate an internal rate of return of 11.5%. The market value of Vestor's capital structure is as follows: Source of Capital Market Value Bonds $10,000,000 Preferred...

Please Use Excel To Show All Work, I will like your asnwer if you do this...

Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...

Please use excel and show all work and formulas. (I will give your work a like...

Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...

Could you show your work in Excel Please. Today is your 25th birthday. You have decided...

Could you show your work in Excel Please. Today is your 25th birthday. You have decided that it is necessary to plan your own retirement since you are not confident that government benefits will be available when you retire. You will make annual payments into an account earning 5% APY starting on your next birthday (26th) a year from now. Your last payment will occur on your 70th birthday. You have decided that you need to plan for payments of...

In EXCEL Please: you must show your work in Excel, which includes providing the formulas in...

In EXCEL Please: you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail. JLR Enterprises provides consulting services throughout California and uses a job-order costing system to accumulate the cost of client projects. Traceable costs are charged directly to individual clients; in contrast, other costs incurred by JLR, but not identifiable with specific clients, are...

Subjects