Question: Please explain excel formula as well and solve for the yellow ABC Tech Valuation Estimate Step 1: Calculate FCF Step 2: Calculate Terminal Value Step

Please explain excel formula as well and solve for the yellow Please explain excel formula as well and solve for the yellow ABC

ABC Tech Valuation Estimate Step 1: Calculate FCF Step 2: Calculate Terminal Value Step 3: Calculate PV of FCF and Terminal Value Step 1 Net Income (After Tax) Add back D&A Substract NWC Substract Capex FCF Year 1 ($1,964,633) $396,223 ($2,050,367) ($1,650,000) ($5,268,777) Year 2 $1,066,144 $576,223 ($1,596,144) ($150,000) ($103,777) Year 3 $3,174,038 $756,223 ($3,354,038) Year 4 $6,069,327 $936,223 ($6,249,327) Year 5 $8,922,185 $1,116,223 ($9,102,185) Year 6 $9,368,294.25 $1,172,034.15 ($9,557,294.25) $0.00 $983,034 $0 so Formulas: NOPAT = EBIT (1-t) NOPAT = net operating after-taxes earnings FCF = NOPAT - new net capital expenditures capitalization rate = = WACC-8 Terminal Value = FCF/Ir-g) $576,223 $756,223 $936,223 5% Step 2 Assumed growth rate Use "build-up" rate as WACC Terminal value =====> 16% Step 3 PV of FCF Total Valuation to Equity

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!