Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can i have help answering these please 5 2 1 1 Qla Q1b Qic Qid Qle Q1f Qig Q1h Qli 1 4 1 2 Year

Can i have help answering these please

image text in transcribed

image text in transcribed

5 2 1 1 Qla Q1b Qic Qid Qle Q1f Qig Q1h Qli 1 4 1 2 Year (replace with your firm's year end dates) 30-Dec-17 30-Dec-18 30-Dec-19 30-Dec-20 30-Dec-21 30-Dec-22 30-Dec-23 30-Dec-24 30-Dec-25 Revenue growth rate (For past: calculate based on past revenues. For forecast: provide reasonable estimate. 17.7811% -8.5021% -30.1307% 58.9705% 0.8137% -7.7186% 5.4146% 5.2443% Revenue (For past: retrieve from P&L. For forecast: calculate based on growth rates) 37,162,000 279,332,000 255,583,000 178,574,000 283,880,000 286,190,000 264,100,000 278,400,000 293,000,000 Net Income (For past: retrieve from P&L. For forecast: calculate based on growth rates, or estimate based on forecast P&L done somewhere below line 115) 19,710,000 20,840,000 14,340,000 -22,440,000 Depreciation & amortisation expense (calculate based on growth rates, or estimate based on forecast P&L done somewhere below line 115) Tangible and intangible capital assets, carrying amount (For past: retrieve from balance sheet. For forecast: calculate based on growth rates, or estimate bastorecast balance sheet done somewhere below line 115) Capex (calculate based on above net capital assets and other items) Operating net working capital (For past: retrieve from balance sheet. For forecast: calculate based on growth rates, or estimate based on forecast balance shne somewhere below line 115) DeltaNWC (calculate based on above operating working capital and other items) Interest expense (calculate based on growth rates, or estimate based on forecast P&L done somewhere below line 115) tc, corporate tax rate (feel free to change this if you wish) 0.3 0.3 0.3 0.3 0.3 0.3 OFCF (calculate based on above items) 1 0.3 Q1j 4 -766,000 7,355,000 Income Statement (all numbers in thousands) Breakdown Total Revenue Operating Revenue Cost of Revenue Gross Profit Operating Expense Selling General and Administrative Other Taxes Other Operating Expenses Operating Income Net Non Operating Interest Income Expense Interest Expense Non Operating Other Income Expense Earnings from Equity Interest Other Non Operating Income Expenses Pretax Income Tax Provision Net Income Common Stockholders Net Income Net Income Including Non-Controlling Interests Net Income Continuous Operations Minority Interests Diluted NI Available to Com Stockholders Basic EPS Diluted EPS Basic Average Shares Diluted Average Shares Total Expenses Interest Expense Net Interest Income Net Income from Continuing & Discontinued Operation Normalized Income EBIT EBITDA Reconciled Cost of Revenue Reconciled Depreciation Net Income from Continuing Operation Net Minority Interest Normalized EBITDA Tax Rate for Calcs Tax Effect of Unusual Items 30/17 12/30/18 12/30/19 12/30/20 237,162,000 279,332,000 255,583,000 178,574,000 237,162,000 279,332,000 255,583,000 178,574,000 182,238,000 211,599,000 199,625,000 170,447,000 54,924,000 67,733,000 55,958,000 8,127,000 42,850,000 45,609,000 43,192,000 37,575,000 10,956,000 11,480,000 11,398,000 10,168,000 30,104,000 32,663,000 30,525,000 26,122,000 1,790,000 1,466,000 1,269,000 1,285,000 12,074,000 22,124,000 12,766,000 -29,448,000 -601,000 -830,000 -1,158,000 601,000 766,000 830,000 1,158,000 7,201,000 9,595,000 8,120,000 1,723,000 5,380,000 5,441,000 1,732,000 1,821,000 2,240,000 2,679,000 -9,000 18,674,000 30,953,000 20,056,000 -28,883,000 -1,174,000 9,532,000 5,282,000 -5,632,000 19,710,000 20,840,000 14,340,000 -22,440,000 19,710,000 20,840,000 14,340,000 -22,440,000 19,848,000 21,421,000 14,774,000 -23,251,000 19,848,000 21,421,000 14,774,000 -23,251,000 - 138,000 -581,000 434,000 811,000 19,710,000 20,840,000 14,340,000 -22,440,000 4.63 4.88 3.36 -5.25 4.63 4.88 3.36 -5.25 4,256,000 4,237,000 4,234,000 4,274,286 4,256,000 4,237,000 4,270,000 4,274,286 225,088,000 257,208,000 242,817,000 208,022,000 601,000 766,000 830,000 1,158,000 -601,000 -766,000 -830,000 -1,158,000 19,710,000 20,840,000 14,340,000 -22,440,000 19,710,000 20,840,000 14,340,000 -22,440,000 19,275,000 31,719,000 20,886,000 -27,725,000 182,238,000 19,893,000 19,710,000 39,168,000 0 0 211,599,000 199,625,000 170,447,000 18,745,000 18,998,000 46,009,000 20,840,000 14,340,000 -22,440,000 50,464,000 39,884,000 18,284,000 0 0 0 o 0 0 0 5 2 1 1 Qla Q1b Qic Qid Qle Q1f Qig Q1h Qli 1 4 1 2 Year (replace with your firm's year end dates) 30-Dec-17 30-Dec-18 30-Dec-19 30-Dec-20 30-Dec-21 30-Dec-22 30-Dec-23 30-Dec-24 30-Dec-25 Revenue growth rate (For past: calculate based on past revenues. For forecast: provide reasonable estimate. 17.7811% -8.5021% -30.1307% 58.9705% 0.8137% -7.7186% 5.4146% 5.2443% Revenue (For past: retrieve from P&L. For forecast: calculate based on growth rates) 37,162,000 279,332,000 255,583,000 178,574,000 283,880,000 286,190,000 264,100,000 278,400,000 293,000,000 Net Income (For past: retrieve from P&L. For forecast: calculate based on growth rates, or estimate based on forecast P&L done somewhere below line 115) 19,710,000 20,840,000 14,340,000 -22,440,000 Depreciation & amortisation expense (calculate based on growth rates, or estimate based on forecast P&L done somewhere below line 115) Tangible and intangible capital assets, carrying amount (For past: retrieve from balance sheet. For forecast: calculate based on growth rates, or estimate bastorecast balance sheet done somewhere below line 115) Capex (calculate based on above net capital assets and other items) Operating net working capital (For past: retrieve from balance sheet. For forecast: calculate based on growth rates, or estimate based on forecast balance shne somewhere below line 115) DeltaNWC (calculate based on above operating working capital and other items) Interest expense (calculate based on growth rates, or estimate based on forecast P&L done somewhere below line 115) tc, corporate tax rate (feel free to change this if you wish) 0.3 0.3 0.3 0.3 0.3 0.3 OFCF (calculate based on above items) 1 0.3 Q1j 4 -766,000 7,355,000 Income Statement (all numbers in thousands) Breakdown Total Revenue Operating Revenue Cost of Revenue Gross Profit Operating Expense Selling General and Administrative Other Taxes Other Operating Expenses Operating Income Net Non Operating Interest Income Expense Interest Expense Non Operating Other Income Expense Earnings from Equity Interest Other Non Operating Income Expenses Pretax Income Tax Provision Net Income Common Stockholders Net Income Net Income Including Non-Controlling Interests Net Income Continuous Operations Minority Interests Diluted NI Available to Com Stockholders Basic EPS Diluted EPS Basic Average Shares Diluted Average Shares Total Expenses Interest Expense Net Interest Income Net Income from Continuing & Discontinued Operation Normalized Income EBIT EBITDA Reconciled Cost of Revenue Reconciled Depreciation Net Income from Continuing Operation Net Minority Interest Normalized EBITDA Tax Rate for Calcs Tax Effect of Unusual Items 30/17 12/30/18 12/30/19 12/30/20 237,162,000 279,332,000 255,583,000 178,574,000 237,162,000 279,332,000 255,583,000 178,574,000 182,238,000 211,599,000 199,625,000 170,447,000 54,924,000 67,733,000 55,958,000 8,127,000 42,850,000 45,609,000 43,192,000 37,575,000 10,956,000 11,480,000 11,398,000 10,168,000 30,104,000 32,663,000 30,525,000 26,122,000 1,790,000 1,466,000 1,269,000 1,285,000 12,074,000 22,124,000 12,766,000 -29,448,000 -601,000 -830,000 -1,158,000 601,000 766,000 830,000 1,158,000 7,201,000 9,595,000 8,120,000 1,723,000 5,380,000 5,441,000 1,732,000 1,821,000 2,240,000 2,679,000 -9,000 18,674,000 30,953,000 20,056,000 -28,883,000 -1,174,000 9,532,000 5,282,000 -5,632,000 19,710,000 20,840,000 14,340,000 -22,440,000 19,710,000 20,840,000 14,340,000 -22,440,000 19,848,000 21,421,000 14,774,000 -23,251,000 19,848,000 21,421,000 14,774,000 -23,251,000 - 138,000 -581,000 434,000 811,000 19,710,000 20,840,000 14,340,000 -22,440,000 4.63 4.88 3.36 -5.25 4.63 4.88 3.36 -5.25 4,256,000 4,237,000 4,234,000 4,274,286 4,256,000 4,237,000 4,270,000 4,274,286 225,088,000 257,208,000 242,817,000 208,022,000 601,000 766,000 830,000 1,158,000 -601,000 -766,000 -830,000 -1,158,000 19,710,000 20,840,000 14,340,000 -22,440,000 19,710,000 20,840,000 14,340,000 -22,440,000 19,275,000 31,719,000 20,886,000 -27,725,000 182,238,000 19,893,000 19,710,000 39,168,000 0 0 211,599,000 199,625,000 170,447,000 18,745,000 18,998,000 46,009,000 20,840,000 14,340,000 -22,440,000 50,464,000 39,884,000 18,284,000 0 0 0 o 0 0 0

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_2

Step: 3

blur-text-image_3

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

Fundamentals of Financial Management

Authors: Eugene F. Brigham

Concise 9th Edition

1305635937, 1305635930, 978-1305635937

More Books

Students also viewed these Finance questions

Question

What is liquidation ?

Answered: 1 week ago

Question

Explain the different types of Mergers.

Answered: 1 week ago

Question

What is dividend payout ratio ?

Answered: 1 week ago