Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 EquityStep 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