Answered step by step
Verified Expert Solution
Link Copied!

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 image text in transcribed

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

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

Finance for Executives Managing for Value Creation

Authors: Gabriel Hawawini, Claude Viallet

4th edition

9781133169949, 538751347, 978-0538751346

More Books

Students also viewed these Finance questions