Question
Answer with formulas for each box. AutoSave Home Insert H28 Draw Page Layout c Formulas D Data Review View Automate Q Tell me Acct- Excel
Answer with formulas for each box.
AutoSave Home Insert H28 Draw Page Layout c Formulas D Data Review View Automate Q Tell me Acct- Excel Case 2 v O (Present) $1,200,000 C) Comments B e Share v o A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 J ** *Enter cash outflows as negative values *** Land O'Lakes' is considering purchasing a small factory building to increase their manufacturing potential. They plan to sell the building in 5 years to upgrade. Information related to this purchase is provided below. Year Building Cost Sales 1 2 3 4 5 Building Cost: Cost of Capital: Years Until Sale of Building: Expected Sale Price: Investment in Working Capital: Depreciation Per Year: Amounts per Year: 1 2 3 4 5 $1,200,000 11% 5 $995,000 $250,000 $120,000 Sales: $490,000 $640,000 $673,000 $795,000 $980,000 Gain on Sale of Building Total Revenue Variable Costs Contribution Margin Fixed Costs Building Depreciation Net Income Annual Building Depreciation Sales Amount Less Gain Working Capital Cash Flow Book Value of Building Net Present Value Profitability Index Internal Rate of Return Simple Rate of Return 1 Fixed Cost excluding Variable cost: Depreciation: $230,300 $300,800 $316,310 $373,650 $115,000 $115,000 $115,000 $115,000 $115,000 $460,600 2. Make or Buy 3. Special Order *Hint: See Instructions Document *Hint: See Instructions Document *Hint: See Instructions Document *Hint: See Instructions Document 6. Capital Budget 1. Keep or Drop Segment Manufacturing Info Accessibility: Investigate 4. Constrained Resource 5. Sell or Process Further Ready *Hint: Gain = Expected Sales Price - Book Value *Hint: =Exepcted Sales Price - Gain Calculated A *Hint: Book Value = Price Paid - Accumulated D 139%
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started