SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both-clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. Forecasted Income Statement (25 points) Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares Earnings per Share Forecasted Balance Sheet (30 points) ASSETS Cash Marketable Securities Accounts Receivable Inventory Total Current Assets: Plant and equipment Less: accumulated depreciation Net Plant and equipment Total Assets LIABILITIES & STOCKHOLDER'S EQUITY Accounts Payable Accrued Expenses Total Current Liabilities Long-term Liabilities Total Liabilities Common Stock ($1 par) Capital paid in excess of par Retained Earnings Total Stockholder's Equity Total Liabilities & Stockholder's Equity 2020 1,200,000 (800,000) 400,000 (304,900) 95,100 (35,000) 60,100 (36,900) 23,200 60,000 $0.39 2020 30,000 20,000 170,000 230,000 450,000 650,000 (65,000) 585,000 1.035.000 200,000 20,400 220,400 325,000 545,400 60,000 190,000 239,600 489,600 1.035,000 2021 DURA-CLEAR WINDOWS, LLC Proforma Income Statement 1,500,000 (1,040,000) 460,000 (350,500) 109,500 (45,000) 64,500 (49,200) 15,300 60,000 $0.26 2021 40,000 25,000 259,000 261,000 585,000 765,000 (141,500) 623,500 1,208,500 310,000 30,000 340,000 363,600 703,600 60,000 2022 190,000 254,900 504,900 1.208.500 1,875,000 (1,105,000) 770,000 (443,700) 326,300 (85,000) 241,300 (55,600) 185,700 78,000 $2.38 DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet 2022 30,000 30,000 360,000 290,000 710,000 1,390,000 (280,500) 1,109,500 1.819.500 505,000 35,000 540,000 703,900 1,243,900 2023 78,000 262,000 235,600 575,600 1.819.500 3,750,000 (1,835,000) 1,915,000 (1,048,098) 866,902 (60,390) 806,512 (290,344) 516,167 176,000 $2.93 2023 50,000 30,000 646,721 640,164 1,366,885 2,140,000 (494,500) 1,645,500 3.012.385 795,065 70,000 865,065 603,900 1,468,965 176,000 1,914,000 (546,580) 1.543.420 3.012.385 2024 2025 2024 2026 5,109,375 6,961,523 9,485,076 12,923,416 (2,500,188) (3,406,505) (4,641,364) (6,323,858) 4,843,712 6,599,558 2,609,188 3,555,018 (1,277,959) (1,591,144) (2,017,859) (2,599,258) 1,331,228 1,963,874 2,825,853 4,000,300 (50,390) (40,390) (30,390) (20,390) 1,280,838 1,923,484 2,795,463 3,979,910 (461,102) (692,454) (1,006,367) (1,432,768) 819,737 1,231,030 1,789,096 2,547,142 176,000 176,000 176,000 176,000 $6.99 $4.66 $10.17 2025 2027 2026 $14.47 2027 50,000 50,000 50,000 30,000 30,000 30,000 881,158 1,200,577 1,635,787 2,228,760 2,206,161 872,223 1,188,404 1,619,201 1,833,381 2,468,982 3,334,988 4,514,921 2,140,000 2,140,000 2,140,000 2,140,000 (708,500) (922,500) (1,136,500) (1,350,500) 1,431,500 1,217,500 1,003,500 789,500 3.264,881 3.686.482 4.338.488 5.304.421 50,000 30,000 1,066,408 2,626,157 241,237 2,867,394 203,900 3,071,294 1,436,113 1,939,835 95,375 129,948 177,055 1,161,783 1,566,061 2,116,890 503,900 403,900 303,900 1,665,683 1,969,961 2,420,790 176,000 176,000 176,000 176,000 1,914,000 1,914,000 1,914,000 1,914,000 (490,802) (373,479) (172,302) 143,126 1.599.198 1.716.521 1.917.698 2.233.126 3.264.881 3.686.482 4.338.488 5.304.421 1 2 3 4 (16 pts) Based upon your financial forecast for the years 2023-2027, compute the following, placing your final results in the yellow highlighted area. HINT: Taxes should NOT be included in your Fixed or Variable costs for this computation. a b d e f a b d Total Fixed Costs Total Variable Costs Contribution Margin ratio (See Week 5 Lesson) e Breakeven in sales dollars (See Week 5 Lesson) DOL DFL Net Income Change in Current Assets Change in Current Liabilities Depreciation Expense Cash Flows from Operations (Total for company) Cash Flows from Operations (shark only) (17 pts) Based upon your financial forecast for the years 2023-2027, computea-e below FROM THE VIEWPOINT OF THE SHARK, placing your final results in the yellow highlighted area. (HINT: Remember the shark has only 48% ownership!) Payback (in years) of the shark's $1M investment (x.xx years) IRR of shark's investment 2 pts 2 pts NPV of shark's investment 3 pts 3 pts 3 pts 3 pts 3 pts 3 pts 3 pts 4 pts 4 pts ($1,000,000) ($1,000,000) (3 pts) What is the growth rate of earnings for each of the forecasted years? 2023 (4 pts) Compute the following for the forecasted years. (Total company) 3 pts Free Cash Flow 1 pt Free Cash Flow per share 2023 2023 2024 2023 2024 2024 2025 2024 2025 2025 2026 2025 2026 2026 2026 2027 2027 2027 2027 SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both-clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. Forecasted Income Statement (25 points) Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares Earnings per Share Forecasted Balance Sheet (30 points) ASSETS Cash Marketable Securities Accounts Receivable Inventory Total Current Assets: Plant and equipment Less: accumulated depreciation Net Plant and equipment Total Assets LIABILITIES & STOCKHOLDER'S EQUITY Accounts Payable Accrued Expenses Total Current Liabilities Long-term Liabilities Total Liabilities Common Stock ($1 par) Capital paid in excess of par Retained Earnings Total Stockholder's Equity Total Liabilities & Stockholder's Equity 2020 1,200,000 (800,000) 400,000 (304,900) 95,100 (35,000) 60,100 (36,900) 23,200 60,000 $0.39 2020 30,000 20,000 170,000 230,000 450,000 650,000 (65,000) 585,000 1.035.000 200,000 20,400 220,400 325,000 545,400 60,000 190,000 239,600 489,600 1.035,000 2021 DURA-CLEAR WINDOWS, LLC Proforma Income Statement 1,500,000 (1,040,000) 460,000 (350,500) 109,500 (45,000) 64,500 (49,200) 15,300 60,000 $0.26 2021 40,000 25,000 259,000 261,000 585,000 765,000 (141,500) 623,500 1,208,500 310,000 30,000 340,000 363,600 703,600 60,000 2022 190,000 254,900 504,900 1.208.500 1,875,000 (1,105,000) 770,000 (443,700) 326,300 (85,000) 241,300 (55,600) 185,700 78,000 $2.38 DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet 2022 30,000 30,000 360,000 290,000 710,000 1,390,000 (280,500) 1,109,500 1.819.500 505,000 35,000 540,000 703,900 1,243,900 2023 78,000 262,000 235,600 575,600 1.819.500 3,750,000 (1,835,000) 1,915,000 (1,048,098) 866,902 (60,390) 806,512 (290,344) 516,167 176,000 $2.93 2023 50,000 30,000 646,721 640,164 1,366,885 2,140,000 (494,500) 1,645,500 3.012.385 795,065 70,000 865,065 603,900 1,468,965 176,000 1,914,000 (546,580) 1.543.420 3.012.385 2024 2025 2024 2026 5,109,375 6,961,523 9,485,076 12,923,416 (2,500,188) (3,406,505) (4,641,364) (6,323,858) 4,843,712 6,599,558 2,609,188 3,555,018 (1,277,959) (1,591,144) (2,017,859) (2,599,258) 1,331,228 1,963,874 2,825,853 4,000,300 (50,390) (40,390) (30,390) (20,390) 1,280,838 1,923,484 2,795,463 3,979,910 (461,102) (692,454) (1,006,367) (1,432,768) 819,737 1,231,030 1,789,096 2,547,142 176,000 176,000 176,000 176,000 $6.99 $4.66 $10.17 2025 2027 2026 $14.47 2027 50,000 50,000 50,000 30,000 30,000 30,000 881,158 1,200,577 1,635,787 2,228,760 2,206,161 872,223 1,188,404 1,619,201 1,833,381 2,468,982 3,334,988 4,514,921 2,140,000 2,140,000 2,140,000 2,140,000 (708,500) (922,500) (1,136,500) (1,350,500) 1,431,500 1,217,500 1,003,500 789,500 3.264,881 3.686.482 4.338.488 5.304.421 50,000 30,000 1,066,408 2,626,157 241,237 2,867,394 203,900 3,071,294 1,436,113 1,939,835 95,375 129,948 177,055 1,161,783 1,566,061 2,116,890 503,900 403,900 303,900 1,665,683 1,969,961 2,420,790 176,000 176,000 176,000 176,000 1,914,000 1,914,000 1,914,000 1,914,000 (490,802) (373,479) (172,302) 143,126 1.599.198 1.716.521 1.917.698 2.233.126 3.264.881 3.686.482 4.338.488 5.304.421 1 2 3 4 (16 pts) Based upon your financial forecast for the years 2023-2027, compute the following, placing your final results in the yellow highlighted area. HINT: Taxes should NOT be included in your Fixed or Variable costs for this computation. a b d e f a b d Total Fixed Costs Total Variable Costs Contribution Margin ratio (See Week 5 Lesson) e Breakeven in sales dollars (See Week 5 Lesson) DOL DFL Net Income Change in Current Assets Change in Current Liabilities Depreciation Expense Cash Flows from Operations (Total for company) Cash Flows from Operations (shark only) (17 pts) Based upon your financial forecast for the years 2023-2027, computea-e below FROM THE VIEWPOINT OF THE SHARK, placing your final results in the yellow highlighted area. (HINT: Remember the shark has only 48% ownership!) Payback (in years) of the shark's $1M investment (x.xx years) IRR of shark's investment 2 pts 2 pts NPV of shark's investment 3 pts 3 pts 3 pts 3 pts 3 pts 3 pts 3 pts 4 pts 4 pts ($1,000,000) ($1,000,000) (3 pts) What is the growth rate of earnings for each of the forecasted years? 2023 (4 pts) Compute the following for the forecasted years. (Total company) 3 pts Free Cash Flow 1 pt Free Cash Flow per share 2023 2023 2024 2023 2024 2024 2025 2024 2025 2025 2026 2025 2026 2026 2026 2027 2027 2027 2027
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Product is Hydro Flask food container Target segment is - outdoorsy people in the late 20s to early 40s age range. These customers spend a large portion of their time on outdoors adventures whether...
-
Factories in four states supply the University of Maryland Bookstore with Under Armour apparel in the following proportions: Texas - 0.22, Iowa - 0.24, West Virginia - 0.18 and Maryland = the rest....
-
b) Calculate the Fault Level in MVA if a symmetrical bolted 3-phase fault occurs on the LV side of the 5MVA Transformer at 11kV c) The Tranformer impedance is 6% - Calculate the short circuit current.
-
An astronaut uses a Body Mass Measurement Device (BMMD) to determine her mass. What is the astronaut's mass, given that the force constant of the BMMD is 2600 N/m and the period of oscillation is...
-
In the bus scheduling example suppose that buses can run either 8- or 12-hour shifts. If a bus runs for 12 hours, the driver is paid for the extra hours at 150% of the regular hourly pay. Do you...
-
Consider the following cash flow profile, and assume MARR is 10 percent/year. a. What does Descartes' rule of signs tell us about the IRR(s) of this project? b. What does Norstrom's criterion tell us...
-
The Molokai Nut Company (MNC) makes four different products from macadamia nuts grown in the Hawaiian Islands: chocolate-coated whole nuts (Whole), chocolate-coated nut clusters (Cluster),...
-
What are the key components of a relational database management system? Why are relational database management systems different from database models that preceded the relational model?
-
Saint Leo is developing a plan to promote their new Center in your hometown. The University's marketing director wants to use a varied and balanced approach to IMC. For each of the five IMC types...
-
Omphalophobia is the distinct fear associated with which anatomical feature, scientifically classified as the umbilicus?
-
then When considering cost and revenue curves for a monopolist, the total cost curve will then _________. The total revenue curve will ----- rise, fall rapidly; rise, fall O rise, decrease; rise,...
-
Consider the indifference curves below. Moving outward from IC to IC, IC3, and IC4, we get Chicken Meals per Week O 8 4 2 y 0 2 3 7 Vegetarian Meals per Week a.) higher levels of satisfaction b.)...
-
There are two goods and two consumers. Preferences and endowments are described by u(x, x2) = min(x, x2) e = (30, 0), (p. y) = y/2 P1 P2 e = (0, 20), and and respectively. (a) Find a Walrasian...
-
2) The nominal interest rate is A) the interest rate measured in terms of goods. B) always less than the real interest rate. C) equal to the real interest rate minus the rate of inflation. D) the...
-
Benzene can be sulfonated by concentrated sulphuric acid: C6H6+ HSO4 C6H3SO3 + HO* This reaction occurs by the following three-step mechanism: Step 1: HSO4- SO3 + HO Step 2: SO3 + C6H6 Step 3:...
-
The Central Valley Company has prepared department overhead budgets for budgeted-volume levels before allocations as follows: Management has decided that the most appropriate inventory costs are...
-
A copper wire (density = 8.96 g/cm 3 ) has a diameter of 0.25 mm. If a sample of this copper wire has a mass of 22 g, how long is the wire?
-
Mike sells his home to Jane on April 2, 2012. Jane pays the property taxes covering the full calendar year in October, which amount to $2,500. How much may Mike and Jane each deduct for property...
-
Fisafolia Corporation has gross income from operations of $220,000 and operating expenses of $160,000 for 2012. The corporation also has $20,000 in dividends from publicly traded domestic...
-
Mike purchases a heavy-duty truck (5-year class recovery property) for his delivery service on April 30, 2012. The truck is not considered a passenger automobile for purposes of the listed property...
-
The sequence in Figure P2.2 represents a ball rolling into a wall and bouncing off of it. The ball is \(10 \mathrm{~mm}\) in diameter. Make a graph showing the distance from the leading edge of the...
-
You walk \(3.2 \mathrm{~km}\) to the supermarket and then back home. What is your distance traveled? What is your displacement?
-
Your class observed several different objects in motion along different lines. Figure P2.5 shows some of the graphs other students made of the events. They have labeled the horizontal axis "time" and...
Study smarter with the SolutionInn App