CourseLover

(12)

$10/per page/Negotiable

About CourseLover

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Engineering,Health & Medical,HR Management,Law,Marketing,Math,Physics,Psychology,Programming,Science Hide all
Teaching Since: May 2017
Last Sign in: 287 Weeks Ago, 2 Days Ago
Questions Answered: 27237
Tutorials Posted: 27372

Education

  • MCS,MBA(IT), Pursuing PHD
    Devry University
    Sep-2004 - Aug-2010

Experience

  • Assistant Financial Analyst
    NatSteel Holdings Pte Ltd
    Aug-2007 - Jul-2017

Category > Accounting Posted 10 Dec 2017 My Price 10.00

Calculating of Free Cash Flow

Following is the question and response. How do I set this answer up on a spreadsheet with calculations.  I have other responses to add to the spreadsheet, but is I can get assistance setting up the spreadsheet I feel I can continue from that point.  Mamie Smith

What is the free cash flow for 2014? 

 

Calculating of Free Cash Flow

            Free cash flow is the sum of the net operating profit after taxes (NOPAT). 

FCF = NOPAT – Net investment in operating capital

NOPAT = EBIT (1-Tax rate)

NOPAT for 2012 = EBIT for 2012 (1- 0.40)

NOPAT = ($209,100) (0.60)

            NOPAT for 2012 = $125,460

 

NOPAT for 2014 = EBIT for 2014 (1- 0.40)

                             = ($502,640) (0.60)

            NOPAT for 2014 = $301,584          

Net investment in operating capital for 2014 = NOPAT for 2014 – NOPAT for 2012

                                                         = ($301,584) – ($125,460)

Net investment in operating capital for 2014 =  $ 176,124  Calculating for Free cash flow for 2014:

2014 Free cash flow (FCF) = NOPAT for 2014 – Net investment in operating capital                                                     for 2014

                                               = ($10,464) – (-$114,996)

2013 Free cash flow = - $104,532

FCF = NOPAT – Net investment in operating capital

 

 

 

Calculating of Free Cash Flow

            Free cash flow is the sum of the net operating profit after taxes (NOPAT). 

FCF = NOPAT – Net investment in operating capital

NOPAT = EBIT (1-Tax rate)

NOPAT for 2012 = EBIT for 2012 (1- 0.40)

NOPAT = ($209,100) (0.60)

            NOPAT for 2012 = $125,460

Answers

CourseLover
(12)
Status NEW Posted 10 Dec 2017 10:12 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------

Not Rated(0)