What is The working capital and cash flow per year?

***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 I Sales 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 O (Present) ($600,000 ($800,000) $600,000 1 $390,000 $390,000 ($198,900) $191,100 ($100,000) ($60,000) $31,100 ($60,000) $91,100 $540,000 2 $498,000 $498,000 ($253,980) $244,020 ($100,000) ($60,000) $84,020 ($120,000) $480,000 3 513,000 $513,000 ($261,630) $251,370 ($100,000) ($60,000) $91,370 ($180,000) $420,000 4 $620,000 $620,000 ($316,200) $303,800 ($100,000) ($60,000) $143,800 ($240,000) $360,000 5 $740,000 $325,000 *Hint: Gain - - Expected Sales Price - Book Value of Building When Sold 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 $600,000 11% 5 $625,000 $200,000 $60,000 Sales: $390,000 $498,000 $513,000 $620,000 $740,000 $740,000 ($377,400 $362,600 ($100,000 ($60,000) $202,600 ($300,000 $300,000 *Hint : =Exepcted Sales Price- Gain Calculated Above Fixed Cost excluding Variable cost: Depreciation: $198,900 $253,980 $261,630 $316,200 $377,400 $100,000 $100,000 $100,000 $100,000 $100,000 $300,000 *Hint: Book Value = Price Paid - Accumulated Depreciation *Hint: See Instructions Document *Hint: See Instructions Document *Hint: See Instructions Document *Hint: See Instructions Document ***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 I Sales 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 O (Present) ($600,000 ($800,000) $600,000 1 $390,000 $390,000 ($198,900) $191,100 ($100,000) ($60,000) $31,100 ($60,000) $91,100 $540,000 2 $498,000 $498,000 ($253,980) $244,020 ($100,000) ($60,000) $84,020 ($120,000) $480,000 3 513,000 $513,000 ($261,630) $251,370 ($100,000) ($60,000) $91,370 ($180,000) $420,000 4 $620,000 $620,000 ($316,200) $303,800 ($100,000) ($60,000) $143,800 ($240,000) $360,000 5 $740,000 $325,000 *Hint: Gain - - Expected Sales Price - Book Value of Building When Sold 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 $600,000 11% 5 $625,000 $200,000 $60,000 Sales: $390,000 $498,000 $513,000 $620,000 $740,000 $740,000 ($377,400 $362,600 ($100,000 ($60,000) $202,600 ($300,000 $300,000 *Hint : =Exepcted Sales Price- Gain Calculated Above Fixed Cost excluding Variable cost: Depreciation: $198,900 $253,980 $261,630 $316,200 $377,400 $100,000 $100,000 $100,000 $100,000 $100,000 $300,000 *Hint: Book Value = Price Paid - Accumulated Depreciation *Hint: See Instructions Document *Hint: See Instructions Document *Hint: See Instructions Document *Hint: See Instructions Document