Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete pro forma statements for the years 2015-2019, assuming an 8% growth rate for all line items. The cells that need to be completed are
- Complete pro forma statements for the years 2015-2019, assuming an 8% growth rate for all line items. The cells that need to be completed are shaded in yellow.
Balance sheet
Period Ending | 31-Dec-14 | 31-Dec-13 | 31-Dec-12 | 2015 | 2016 | 2017 | 2018 | 2019 | |||
Assets | |||||||||||
Current Assets | |||||||||||
Cash And Cash Equivalents | 1,113,608 | 604,965 | 290,291 | ||||||||
Short Term Investments | 494,888 | 595,440 | 457,787 | ||||||||
Net Receivables | - | - | - | ||||||||
Inventory | - | - | - | ||||||||
Other Current Assets | 2,331,973 | 1,858,358 | 1,492,713 | ||||||||
Total Current Assets | 3,940,469 | 3,058,763 | 2,240,791 | ||||||||
Long Term Investments | - | - | - | ||||||||
Property Plant and Equipment | 149,875 | 133,605 | 131,681 | ||||||||
Goodwill | - | - | - | ||||||||
Intangible Assets | 2,773,326 | 2,091,071 | 1,506,008 | ||||||||
Accumulated Amortization | - | - | - | ||||||||
Other Assets | 192,981 | 129,124 | 89,410 | ||||||||
Deferred Long Term Asset Charges | - | - | - | ||||||||
Total Assets | 7,056,651 | 5,412,563 | 3,967,890 | ||||||||
Liabilities | |||||||||||
Current Liabilities | |||||||||||
Accounts Payable | 271,327 | 162,453 | 139,607 | ||||||||
Short/Current Long Term Debt | - | - | - | ||||||||
Other Current Liabilities | 2,391,827 | 1,991,750 | 1,536,319 | ||||||||
Total Current Liabilities | 2,663,154 | 2,154,203 | 1,675,926 | ||||||||
Long Term Debt | 900,000 | 500,000 | 400,000 | ||||||||
Other Liabilities | 1,635,789 | 1,424,799 | 1,147,291 | ||||||||
Deferred Long Term Liability Charges | - | - | - | ||||||||
Minority Interest | - | - | - | ||||||||
Negative Goodwill | - | - | - | ||||||||
Total Liabilities | 5,198,943 | 4,079,002 | 3,223,217 | ||||||||
Stockholders' Equity | |||||||||||
Misc Stocks Options Warrants | - | - | - | ||||||||
Redeemable Preferred Stock | - | - | - | ||||||||
Preferred Stock | - | - | - | ||||||||
Common Stock | 60 | 60 | 56 | ||||||||
Retained Earnings | 819,284 | 552,485 | 440,082 | ||||||||
Treasury Stock | - | - | - | ||||||||
Capital Surplus | 1,042,810 | 777,441 | 301,616 | ||||||||
Other Stockholder Equity | -4,446 | 3,575 | 2,919 | ||||||||
Total Stockholder Equity | 1,857,708 | 1,333,561 | 744,673 | ||||||||
Net Tangible Assets | -915,618 | -757,510 | -761,335 |
Income Statement
Period Ending | 31-Dec-14 | 31-Dec-13 | 31-Dec-12 | 2015 | 2016 | 2017 | 2018 | 2019 | |||
Total Revenue | 5,504,656 | 4,374,562 | 3,609,282 | ||||||||
Cost of Revenue | 3,752,760 | 3,117,203 | 2,652,058 | ||||||||
Gross Profit | 1,751,896 | 1,257,359 | 957,224 | ||||||||
Operating Expenses | |||||||||||
Research Development | 472,321 | 378,769 | 329,008 | ||||||||
Selling General and Administrative | 876,927 | 650,243 | 578,224 | ||||||||
Non Recurring | - | - | - | ||||||||
Others | - | - | - | ||||||||
Total Operating Expenses | - | - | - | ||||||||
Operating Income or Loss | 402,648 | 228,347 | 49,992 | ||||||||
Income from Continuing Operations | |||||||||||
Total Other Income/Expenses Net | -3,060 | -28,131 | 474 | ||||||||
Earnings Before Interest And Taxes | 399,588 | 200,216 | 50,466 | ||||||||
Interest Expense | 50,219 | 29,142 | 19,986 | ||||||||
Income Before Tax | 349,369 | 171,074 | 30,480 | ||||||||
Income Tax Expense | 82,570 | 58,671 | 13,328 | ||||||||
Minority Interest | - | - | - | ||||||||
Net Income From Continuing Ops | 266,799 | 87,274 | 17,152 | ||||||||
Non-recurring Events | |||||||||||
Discontinued Operations | - | - | - | ||||||||
Extraordinary Items | - | - | - | ||||||||
Effect Of Accounting Changes | - | - | - | ||||||||
Other Items | - | - | - | ||||||||
Net Income | 266,799 | 112,403 | 17,152 | ||||||||
Preferred Stock And Other Adjustments | - | - | - | ||||||||
Net Income Applicable To Common Shares | 266,799 | 112,403 | 17,152 | ||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
To complete the pro forma statements for the years 20152019 with an 8 growth rate for all line items ...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