Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

How do I determine the capex and depreciation costs from the information provided to create a discounted cash flow model? Digital Everywhere, Inc. Pro Forma

How do I determine the capex and depreciation costs from the information provided to create a discounted cash flow model?

image text in transcribed Digital Everywhere, Inc. Pro Forma Projections (in $,000s) INCOME STATEMENT Net Sales COGS Gross Profit $ $ $ 1998 8,500 3,200 5,300 $ $ $ 1999 15,000 $ 5,600 $ 9,400 $ 2000 35,500 14,000 21,500 $ $ $ 2001 46,000 18,100 27,900 $ $ $ 2002 52,000 20,100 31,900 $ $ $ 2003 60,000 24,500 35,500 SG&A R&D Earnings Before Interest and Tax $ $ $ 3,500 1,100 700 $ $ $ 5,410 $ 2,800 $ 1,190 $ 6,400 4,100 11,000 $ $ $ 5,300 5,400 17,200 $ $ $ 7,200 6,500 18,200 $ $ $ 7,800 7,000 20,700 Income Tax (35%) Net Earnings $ $ 245 455 $ $ 417 $ 774 $ 3,850 7,150 $ $ 6,020 11,180 $ $ 6,370 11,830 $ $ 7,245 13,455 BALANCE SHEET 1998 1999 2000 2001 2002 2003 Cash Accounts Receivable Inventories Other Total Current Assets $ $ $ $ $ 1,000 1,417 400 354 3,171 $ $ $ $ ### 2,500 700 625 4,825 $ $ $ $ $ 4,793 5,917 1,750 1,479 13,939 $ $ $ $ $ 13,907 7,667 2,263 1,917 25,753 $ $ $ $ $ 24,699 8,667 2,513 2,167 38,045 $ $ $ $ $ 37,042 10,000 3,063 2,500 52,605 Net Fixed Assets Total Assets $ $ 906 4,077 $ $ 2,300 $ 7,125 $ 3,200 17,139 $ $ 4,000 29,753 $ $ 4,300 42,345 $ $ 4,500 57,105 Liabilities and Shareholder's Equity Accounts Payables Accrued Expenses Total Current Liabilities $ $ $ 533 607 1,140 $ $ $ 933 $ 1,071 $ 2,005 $ 2,333 2,536 4,869 $ $ $ 3,017 3,286 6,303 $ $ $ 3,350 3,714 7,065 $ $ $ 4,084 4,286 8,370 Net Worth $ 2,936 $ 5,120 $ 12,270 $ 23,450 $ 35,280 $ 48,735 Total Liabilities and Net Worth $ 4,076 $ 7,125 $ 17,139 $ 29,753 $ 42,345 $ 57,105

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Managerial Accounting

Authors: John J. Wild, Ken W. Shaw

2010 Edition

978-0073379586

Students also viewed these Accounting questions