Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is a fill in the blank assignment. The spaces left blank are the problems that need to be solved. Edit: The Sales entry in
This is a fill in the blank assignment. The spaces left blank are the problems that need to be solved.
Edit: The "Sales" entry in line B needs to be filled. It is marked with a blue border to highlight it.
Watch Facebook wholesale cothing ven Saint Laurent Class Ch 7 Capital Budget Ch 7 Capital Budget Ch 7 Capital Budget Case Study 4 @ File Edit View Insert Format Data Tools Add-ons Help BY 75 View only - . + Purchase of Equipment Sales Units Less: Variable Costs - $30.00 Equals: Contribution Margin Less: Fixed Costs Less: Advertising Operating Income Plus:Depreciation(Cost-Salvage)/Useful Life Equals Cash Flow Working Capital Salvage # Cash Flow Today/Time To Year Year Year Year Year Year 0 1 2 3 4 5 6 $294.000.00 $ 300,000.00 $550,000.00 $650,000.00 $750,000.00 $750,000.00 $750,000.00 6,000.00 11,000.00 13,000.00 15,000.00 15,000.00 15,000.00 S 180,000.00 $330,000.00 $390,000.00 $450,000.00 $450,000.00 $ 450,000.00 $ 120,000.00 $220,000.00 $260,000.00 $300,000.00 $300,000.00 $ 300,000.00 $121.000.00 $171,000.00 $171,000.00 $171,000.00 $171,000.00 $171,000.00 $74,000.00 $74,000.00 $54,000.00 $44,000.00 $44,000.00 $44,000.00 $12,000.00 S (25.000,00) $ 35,000.00 $ 85,000.00 $ 85,000.00 $ 85,000.00 $ 48,000.00 $48,000.00 $48,000.00 $48,000.00 $48,000.00 $ 48,000.00 $7000.00 $ 23,000.00 $ 83,000.00 $133,000.00 $133,000.00 $ 133,000.00 $45.000,00 $ 45,000.00 6,000.00 5839.000.00 $ 177,000.00 $ 23,000,00 S 83,000.00 $133,000.00 $133,000.00 $ 184,000.00 1 0.9259 0.8573 0.7938 0.735 0.6806 0.6302 S - PV Factor or Discount Rate Cost of Capital 8% Present Value of Cash Flow Each Time Period $339,000.00 $71,294.30 $19,717,90 $65,885.40 $97,755.00 $90.519 80 $115,956,80 Summation of PV of Cash Flows - COST-NPV $20,459.40 184000 49 4A Sheet - Plus:Depreciation(Cost-Salvage\/Useful Life Equals Cash Flow Working Capital Salvage Cash Flow $ 35,000.00 585,000.00 S 85,000.00 $ 85,000.00 $ 48,000.00 $48,000.00 $48,000.00 $48,000.00 $48,000.00 $ 48,000.00 (77.000,00) $ 23,000.00 $ 83,000.00 $133,000.00 $133,000.00 $ 133,000.00 -S45.000.00 $ 45,000.00 $ 6,000.00 $339,000,00 S 177,000.00) $ 23,000.00 $ 83,000.00 $133,000.00 $133,000.00 $ 184,000.00 PV Factor or Discount Rate Cost of Capital 8% 1 0.9259 0.8573 0.7938 0.735 0.6806 0.6302 Present Value of Cash Flow Each Time Period $339,000.00 $71.29430 $19,717.90 $65,885.40 $97,755.00 $90,519.80 $115,956.80 Summation of PV of Cash Flows - COSTENPV -$20,459.40 184000 133000 133000 83000 23000 -77000 -339000 Sheet1 MacBook Air 80 AStep 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