Question

Hi every one, I need help with this one please Let’s try to calculate the (projected) FCF of the ...

Hi every one, I need help with this one please

Let’s try to calculate the (projected) FCF of the firm LuluYoga for 2018.

Here is some financial information you have gathered with the help of your intern peers and supervisors at the investment bank.

The analyst team has been talking to the management of LuluYoga and they estimate that sales are going to grow by 5% from 2017 to 2018.

Financial ratios that will allow you to compute the different component of FCF are in the table. Use the historical 3-year average for all financial ratios as your estimate of the financial ratio in 2018, with two exceptions: ARDOH and APDOH. You talked to senior managers of the firm and are very confident that in 2018 AR/DOH will be 45 and AP DOH will be 20.

The corporate tax rate is 35%

2015 2016 2017 2018 (projected)
Sales 4,000,000 6,000,000 9,000,000
COGS/Sales 60.20% 60.60% 60.40%
OpExp/Sales 23.00% 22.80% 22.60%
AR/DOH 29 35 36 45
Inv DOH 45 44 46
NFATO 13 13.5 13.2
AP DOH 20 20
Initial inventory 196,877

Answer the following questions. (When you fill in the blanks, don’t keep any decimal points, but rather round your answer. For example, if your computation shows 100.7, then enter 101. )

Question is : What is the change in NOWC?

Hint: there are two parts, operating current asset and operating current liability. To find the change in operating current asset, you may want to calculate the AR and Inventory in both year 2017 and projected year 2018.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

รา us Sabs COS 9 4S0000 Go. (40 22-ko S iven in the fbl CS GS (Z 20 Nf4T0 As Phviedbe COGs 2 200 2159.600 22.goYo。.4Sr山 15S2Nop1t P -T

Add a comment
Know the answer?
Add Answer to:
Hi every one, I need help with this one please Let’s try to calculate the (projected) FCF of the ...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • I need help please. I forgot the formulas for every part of the question Use the...

    I need help please. I forgot the formulas for every part of the question Use the following financial statements for Lake of Egypt Marino, Inc. 2018 2017 $ 60 72 110 LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2018 and 2017 (in millions of dollars) 2018 2017 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable $ 100 $ 48 Accrued wages and taxes securities Accounts receivable 110 Accounts payable Inventory 301 174 Notes...

  • This is due tomorrow morning at 8 am central time. please help! This problem set ses...

    This is due tomorrow morning at 8 am central time. please help! This problem set ses a bit long (35 questions) but in fact it is very simple! . The first 30 questions will help you understand how you extract Free Cash Flows (FCFS) from financial statements. These questions are not multiple choice questions - you should enter your answers directly • The last 5 questions will ask you to finish the DCF analysis based on the FCFs obtained. These...

  • Hi all I need some help with this one please. I am not sure of the...

    Hi all I need some help with this one please. I am not sure of the result I find. You are working on your second project as an equity research intern at a bulge investment bank. Your focus is in retail space, especially in the health and fitness sector. Currently, you are gathering information on a fast-growing chain fitness company called LuluYoga. You are interested in calculating the free cash flow of the firm. LuluYoga offers yoga classes in several...

  • please need help on those blue space with answer. thank you Excel Fie Eat View Insert...

    please need help on those blue space with answer. thank you Excel Fie Eat View Insert Format Tools Data Window Helo Complbity Mode Take home problemais · Home Insert Page Layout Formulas Data ReviawVe Formutsing sable Style Denald Jamlson was brought in as an assistant to Freida Pance, Electotron's chalrman, who had the task of getting he company back inte a sound financial pesition. Electotron's 2016 and 2017 balance sheets and income statements together with projections for 2018, are shown...

  • please I need the ones mark in x. thank you Analyzing Segment Disclosures Raytheon Company disclosed...

    please I need the ones mark in x. thank you Analyzing Segment Disclosures Raytheon Company disclosed the following data related to segment sales and operating profits for fiscal 2018. Total Net Sales Operating Income $ millions 2018 2017 2016 2018 2017 2016 Integrated defense systems 55.809 55,456 55,197 $952 5879 5913 Intelligence information and services 6.722 5.806 5.799 506 428 439 Missile systems 8,298 7.320 6,670 973 1,010 921 Space and airborne systems 6.343 6,044 5.811 831 810 760 Forcepoint...

  • Hi I need help with this question please. Account information from the comparative financial statements of...

    Hi I need help with this question please. Account information from the comparative financial statements of Hopkins Ltd. for the year ended December 31 appear below: 2019 2018 Accounts receivable $129,000 $48,900 Accounts payable 62,000 51,000 Accumulated Depreciation 60,000 30,000 Bonds Payable (due June 30, 2030) 200,000 200,000 Building 280,000 280,000 Cash 95,000 42,000 Common Shares 100,000 100,000 Cost of goods sold 510,000 390,000 Depreciation expense 30,000 30,000 Income tax expense 20,000 18,000 Income tax payable 4,000 3,800 Interest expense...

  • Hi all I need some help with this one please. I am not sure of the result I find. You are working...

    Hi all I need some help with this one please. I am not sure of the result I find. You are working on your second project as an equity research intern at a bulge investment bank. Your focus is in retail space, especially in the health and fitness sector. Currently, you are gathering information on a fast-growing chain fitness company called LuluYoga. You are interested in calculating the free cash flow of the firm. LuluYoga offers yoga classes in several...

  • hi, I need help about it: Balance Sheet Project Description: A balance sheet is a section of an annual t...

    hi, I need help about it: Balance Sheet Project Description: A balance sheet is a section of an annual tinancial report that presents the Company's osscts and liabilities. It provides the users of this statement key measures of the Company's liquidity and its ability to meet its current and future obligations as well as summarizes how the assets and liabilities are presented. Ta complete this section, answer the following required question using information taken from the balance sheet for year...

  • I need help with a-e but please focus on d and e. Thank you! You are...

    I need help with a-e but please focus on d and e. Thank you! You are a staff accountant at a confectionary company, Philly Chocolates International the Company" or PCI). The lease on the current multifunction copiers the Company has in its headquarters is almost up PCI has decided to replace the current copiers with Canon imageRunnerAdvanceC55501 copiers. The CFO has asked you to investigate the impact to the financial statements over the next five years if PCI buys the...

  • Hello, looking for help to answer the following questions. Would you please be able to fully answer the question in accordance with the question? I have calculated the different ratios however I do no...

    Hello, looking for help to answer the following questions. Would you please be able to fully answer the question in accordance with the question? I have calculated the different ratios however I do not know how to describe and evaluated it in 100 - 200 words which I would like some help on please.   Thank you very much.   2018 2017 ($'000) Cash and Cash Equivalents Trade Receivables Inventories Total Current Assets Total Assets Total Current Liabilities Total Liabilities Retained Earnings...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT