Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

al Complete this table to find the Cash Flows from Operations (2 marks] T = 345 Use Excel functions and/or formulas to complete the following

image text in transcribed

image text in transcribed
al Complete this table to find the Cash Flows from Operations (2 marks] T = 345 Use Excel functions and/or formulas to complete the following Year 1 Year 2 Year 3 Year 4 Sales 350,000 500,000 650,000 600,000 Variable Costs 150,000 175,000 225,000 210,000 Fixed Costs 100 000 100 000 100,000 100,000 EBT Tax CF from Operations (Excluding CCA] PV of Operating Cash Flows b) Calculate Initial Investment (1 mark) Equipment cost (575,000.00) Investment in Net Working Capital (NWC] (25,000 00] Initial Investment c) What is the PV of CCA Tax Shield (1 mark) C = Capital Cost 575,000.00 d = CCA rate for asset class 20_00% T = Corporate Tax rate r = cost of capital (WACC] rate S = salvage value of asset 30,000 00 n = yes's PV of CCA Tax Shield IDo not adjust this formula d) What is the PV of the ending cash flows? (1 mark) Salvage Value 30,000 00 Return of Net working capital 25,000 00 Ending Cash Flows (CFS] PV of Ending CFs el What is the project NPV? (1 mark) Initial Investment NPV of CF Opns After Tax ( Excluding CCA] PV of Ending Cash flows PV of CCA Tax Shield NPV of Project Proceed with project? (yes or No] Yes / No because NPV > <

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurial Finance

Authors: J. Chris Leach, Ronald W. Melicher

6th edition

1305968352, 978-1337635653, 978-1305968356

More Books

Students also viewed these Finance questions