Question

In: Accounting

Please calculate the projected financial information for 2019E & 2020E. The growth rate is 21%. Revenue...

Please calculate the projected financial information for 2019E & 2020E. The growth rate is 21%.

Revenue 2017A 2018A 2019E 2020E
Total Revenue $7,766,000 $7,782,000
Cost of Revenue $4,299,000 $4,445,000
Gross Profit $3,467,000 $3,337,000
Operating Expenses
Selling General and Administrative $2,303,000 $2,382,000
Total Operating Expenses $6,760,000 $7,000,000
Operating Income or Loss $1,006,000 $782,000
Incoming from Continuing Operations
Total Other Income/Expenses Net ($2,000) ($204,000)
Earnings Before Interest and Taxes $1,006,000 $782,000
Interest Expense ($11,000) ($12,000)
income Before Tax $1,004,000 $578,000
Income Tax Expense $340,000 $294,000
Net Income From Continuing Ops $664,000 $284,000
Net Income per Common Share - Basic 4.91 2.22
Net Income Applicable to Common Shares $134,000 $127,200

Solutions

Expert Solution

Revenue 2017A 2018A 2019E 2020E
Total Revenue $7,766,000 $7,782,000 $       9,416,220 $       11,393,626
Cost of Revenue $4,299,000 $4,445,000 $       5,378,450 $         6,507,925
Gross Profit $3,467,000 $3,337,000 $       4,037,770 $         4,885,702
Operating Expenses
Selling General and Administrative $2,303,000 $2,382,000 $       2,882,220 $         3,487,486
Total Operating Expenses $6,760,000 $7,000,000 $       8,470,000 $       10,248,700
Operating Income or Loss $1,006,000 $782,000 $          946,220 $         1,144,926
Incoming from Continuing Operations
Total Other Income/Expenses Net ($2,000) ($204,000) $        (246,840) $          (298,676)
Earnings Before Interest and Taxes $1,006,000 $782,000 $          946,220 $         1,144,926
Interest Expense ($11,000) ($12,000) $          (14,520) $            (17,569)
income Before Tax $1,004,000 $578,000 $          699,380 $            846,250
Income Tax Expense $340,000 $294,000 $          355,740 $            430,445
Net Income From Continuing Ops $664,000 $284,000 $          343,640 $            415,804
Net Income per Common Share - Basic 4.91 2.22 $                2.23 $                  2.23
Net Income Applicable to Common Shares $134,000 $127,200 $          153,912 $            186,234

Related Solutions

Projected growth rate 20% Tax rate 21% Operating capacity 93% Sales $198,000,000 Cost of goods sold...
Projected growth rate 20% Tax rate 21% Operating capacity 93% Sales $198,000,000 Cost of goods sold 128,600,000 Other expenses 31,500,000 Depreciation 10,500,000 EBIT $27,400,000 Interest 4,350,000 EBT $23,050,000 Taxes (21%) 4,840,500 Net income $18,209,500 Dividends $9,500,000 Additions to retained earnings 8,709,500 Assets Liabilities & Equity Current assets Current liabilities Cash $1,358,000 Accounts payable $2,400,000 Accounts receivable 4,180,000 Notes payable 5,830,000 Inventory 8,753,000 Total $8,230,000 Total $14,291,000 Long-term debt $67,500,000 Owners' equity Fixed assets Common stock and paid-in surplus $8,000,000 Net...
The financial planning committee of Nickel News, Co. has projected a Growth Rate of 8% for...
The financial planning committee of Nickel News, Co. has projected a Growth Rate of 8% for both Sales and Operating Costs for the upcoming year. No external capital will be required, and currently prevailing Interest Rates and Tax Rates are not expected to change. Nickel News Company Income Statement For the (Current)Year Ended ________________ Sales …..................................................... $ 240,000,000 Operating Costs ….................................... 113,000,000 Operating Income …................................ $ 127,000,000 Interest Expense ….................................. 27,000,000 Pre-Tax Income …................................... $ 100,000,000 Income Taxes …....................................... 33,000,000...
Calculate the sustainable growth rate for Big Falls Timber given the following information.
Calculate the sustainable growth rate for Big Falls Timber given the following information. Dividend payout ratio is 30%; Tax rate is 21%; Total debt is $424,500 and Total assets are $913600; Profit Margin ratio is 11.08%; and Sales of $848,375.45
Financial information is presented below for Amazon. Please find the missing amounts. Sales revenue $ (a)...
Financial information is presented below for Amazon. Please find the missing amounts. Sales revenue $ (a) Sales returns and allowances 3,000 Net sales 95,000 Cost of goods sold (b) Gross profit 36,000 Operating expenses (c) Income from operations (d) Other expenses and losses 7,000 Net income 11,000 Please Solve As soon as Solve quickly I get you two UPVOTE directly Thank's Abdul-Rahim Taysir
How to calculate average Annual Growth Rate
How to calculate average Annual Growth Rate
Multi-Stage Growth Rate: Calculate the present value weighted average growth rate for an investment with a...
Multi-Stage Growth Rate: Calculate the present value weighted average growth rate for an investment with a discount rate of 9% and cash flows that grow through Year 10 at g1 and at g2 thereafter in perpetuity, using every combination of g1 (5%, 10%, and 15%) and g2 (23%, 0%, 3%).
Inputs discount rate 22.50% revenue growth rate 2.50% Initial investment $800,000.00 revenue (year 1) $190,000.00 (a)...
Inputs discount rate 22.50% revenue growth rate 2.50% Initial investment $800,000.00 revenue (year 1) $190,000.00 (a) complete table below (8 pts) Cash flows year 0 year 1 year 2 year 3 year 4 year 5 year 6 (b) Calculate NPV and IRR (8 pts) NPV IRR (c) Would you accept in this project? Explain your answer (3 pts) (d) what is the minimum revenue growth rate that would be consistent with accepting this project? (7 pts) Answer: (e) Explain how...
Inputs discount rate 22.50% revenue growth rate 2.50% Initial investment $800,000.00 revenue (year 1) $190,000.00 (a)...
Inputs discount rate 22.50% revenue growth rate 2.50% Initial investment $800,000.00 revenue (year 1) $190,000.00 (a) complete table below (8 pts) Cash flows year 0 year 1 year 2 year 3 year 4 year 5 year 6 (b) Calculate NPV and IRR (8 pts) NPV IRR (c) Would you accept in this project? Explain your answer (3 pts) (d) what is the minimum revenue growth rate that would be consistent with accepting this project? (7 pts) Answer: (e) Explain how...
Draft a spreadsheet showing financial history and projected performance for Nordstrom. The rows should include revenue,...
Draft a spreadsheet showing financial history and projected performance for Nordstrom. The rows should include revenue, expenses, calculated profit, and calculated profit margin. The columns should represent years: two years of history, plus three years of your reasonable future projections. Include a few sentences of key assumptions and conclusions. The spreadsheet must have accurate calculations and look professional on screen and when printed (including a heading and meaningful number formatting). Income Statement All numbers in thousands Revenue 2/2/2019 2/3/2018 1/28/2017...
Using an excel spreadsheet to present your work, calculate the projected revenue collected from federal income...
Using an excel spreadsheet to present your work, calculate the projected revenue collected from federal income taxes, state income taxes, and the local payroll tax for FY 2014 and prepare a revenue estimate for the City of Newark’s Public School System for FY 2015 based on the following information. Assume that no other deductions came from the employee’s salary other than what is listed here. Hint: New employees are not eligible for raises, which are based on performance from the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT