Why choose us?

We understand the dilemma that you are currently in of whether or not to place your trust on us. Allow us to show you how we can offer you the best and cheap essay writing service and essay review service.

Uperficial Casting Company

uperficial Casting Company is considering adding a new line to its product mix. The production line would be set up in unused space in Superficial main plant based in Hollywood, California. The machinery�s invoice price is $208,000, another $12,000 in shipping charges is required, and installation costs would amount to $27,000. The machinery has an economic life of 4 years, and Superficial management has obtained a special tax ruling that places the equipment in MACRS 3-year class. The machinery is expected to have a salvage value of $28,000 after 4 years of use.

The new line would generate incremental sales of 1,325 units per year for all 4 years at an incremental cost of $112 per unit in the first year, excluding depreciation. Costs (excluding depreciation) are expected to increase by 2% per year due to inflation after the first year. Each unit can be sold for $219 in the first year. The sales price is expected to rise by 3.75% in each of the next two years, and then to fall by 8% in the fourth year, due to fast diminishing demand.

To handle the new line, the company will require net operating working capital at 11.5% of the sales anticipated at the end of the next period. In other words, the company will need net operating working capital at time 0 of 11.5% of the sales expected at the end of year 1, etc. Net operating working capital is expected to be fully recoverable at the end of year 4, the last year of the product�s life cycle.

The firm�s marginal tax rate is 38.2%, and its cost of capital is 10.75% per year.

Deliverables (point values shown in parentheses);

(1) (20) Set up a spreadsheet showing input and output sections next to each other to facilitate ease of sensitivity analysis. Input should include all parameters discussed in the text of the problem. Output should include: NPV, IRR, MIRR, PI, Payback Years and a Decision Box (Invest or Don�t Invest). If you want extra credit for including the Discounted Years to Payback, you should include that in your output section, as well.
(2) (50) Show a calculation area separate from the Input and Output area where the parameters used in the calculations are LINKED to the input section, where necessary, and the output in the calculation area is LINKED to the output section. Your logic should be easy to follow. Ideally, MACRS factors, annual depreciation and book value should be shown together on three separate lines. Net Working Capital Requirements should be shown on a line with Changes in Net Working Capital Requirements shown on a line below the Requirements line.
(3) (10) Derive a one way DATA TABLE for one of the variables in the input section versus the NPV of the output section. (5) Graph this table and label the graph following the label standards discussed in class.
(4) (15) Derive a two way DATA TABLE using any two input variables that you like against NPV. Color code the NPV values less than 25% of your best estimate of the NPV. This table should be properly labeled, as well.
(5) All dollar results should be shown in the nearest dollar. All percent values should be shown as xx.xx%. And all years to payback or index values should be shown to two decimal places. Do not round your results until the end of the calculations.

A- (5) Derive a formula for the Discounted Years to Payback for this case and include the result in the Output Section.
B- (10) Use a vertical or horizontal table lookup for revenue. Generate several different revenue tables, using different inflation rates. When creating your graph, do it by showing NPV or IRR vs the different table options.
Discounted Payback Period247000
Ln (1/1-o1xr/cf0)/ln(1+r)0.1275
O1 = Initial Investment (Outflow)
r = Rate0
CF = Periodic cash flows.
#N/AYear 1Year 2Year 3Year 4
Sales Per Unit1325132513251325
Salvage Value   28000
Total Sales (219)290175294164.9294219.7675294961
Sales adjustments3989.9064044.7674045.521803-23214
Cost  of capital 09.75%24082.524082.524082.524082.5
Salvage Value   28000
Total Exp172482.5175132.5177782.545282.5
Net working capital117692.5119032.4116437.2675249678.5
Tax 38.2%44958.5445470.3844479.0361795377.187
Net working Capital 11.5%0.1150.1150.1150.115
Expected sales205852.6208961.5211617.773379203.015
Total Expenses217441220602.9222261.5362140659.69
Net Income72733.9773562.0371958.23129182301.31
Total Net Income400555.5
Cost of Capital increased due to inflation
Increase in Inflation rateInterest∆ Net Income
First Table0.0975400555.54
Second Table0.1275382238.02
Third Table0.1575363920.50
Net Income72733.9773562.0371958.23129182301.31
Net Income68154.5968982.6567378.85129177721.93
Net Income63575.2164403.2762799.47129173142.55
 Year 1Year 2Year 3Year 4 
Sales Per Unit1325132513251325 
Salvage Value   28000 
Total Sales (219)290175294164.9294219.8294961 
Sales adjustments3989.9064044.7674045.522-23214 
Cost  of capital 15.75%38902.538902.538902.538902.5 
Salvage Value   28000 
Total Exp187302.5189952.5192602.560102.5 
Net working capital102872.5104212.4101617.3234858.5 
Tax 38.2%39297.339809.1438817.889715.95 
Net working Capital 11.5%0.1150.1150.1150.115 
Expected sales220672.6223781.5226437.894023.02 
Total Expenses226599.8229761.6231420.3149818.4 
Net Income63575.2164403.2762799.47173142.6 
Total Income363920.5 
All Rights Reserved, scholarpapers.com
Disclaimer: You will use the product (paper) for legal purposes only and you are not authorized to plagiarize. In addition, neither our website nor any of its affiliates and/or partners shall be liable for any unethical, inappropriate, illegal, or otherwise wrongful use of the Products and/or other written material received from the Website. This includes plagiarism, lawsuits, poor grading, expulsion, academic probation, loss of scholarships / awards / grants/ prizes / titles / positions, failure, suspension, or any other disciplinary or legal actions. Purchasers of Products from the Website are solely responsible for any and all disciplinary actions arising from the improper, unethical, and/or illegal use of such Products.