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:
Answer rating: 100% (QA)
To analyze the forecasted income statement and balance sheet for DURACLEAR WINDOWS LLC I will perform calculations based on the provided data Lets start with the income statement 1 Calculate Gross Pro... View the full 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
-
2. Refer to a property insurance coverage. According to experience, we can assume that the loss amount may take the following values: 10, 50, 100, 200, 500, 1000, 10 000 euro. For each possible value...
-
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.
-
A population doubles in size; 10 individuals are removed from a population. Try starting with 100 individuals, and then try to figure out what happens in general. Consider the above actions. Which of...
-
In the United States, there is no capital gains on houses until the last one is sold. Up to that point any gains are considered unrealized capital gains or losses on primary residence. Estimate the...
-
Are certain roles more important than others? If so, which ones are most important? If not, why not?
-
Prepare the journal entries to record the following transactions on Novy Companys books using a perpetual inventory system. (a) On March 2, Novy Company sold $900,000 of merchandise to Opps Company,...
-
please help me with this!! I don't need the work just the answers please!! Estimate the slope of the graph at x = 0. Use the graph below to find the slope of the function at x = 1. Which line is the...
-
Real option analysis can be used to alter the timing, scale, or other aspects of an investment in response to market conditions. Businesses face the dilemma of whether to invest in a project or...
-
Use the appropriate compound interest formula to compute the balance in the account after the stated period of time $19,000 is invested for 2 years with an APR of 5% and daily compounding. The...
-
Why have the changes at Sarah's Snacks not produced the expected results?
-
Brantly Company manufactures two products. Both products have the same sales price, and the volume of sales is equivalent. However, due to the difference in production processes, Product A has higher...
-
Compute the weakest precondition for each of the following statements and postconditions: (1) a = 5 * (c (2) x = 3 * Y 3) + 7 (a > 12) x + 5 {x < 8} (3) a= (2 b + 3); b = 5a + 3; {b < 8} (4) if (x >...
-
Electrons in Earth's upper atmosphere have typical speeds near 6.00 10 5 m/s. (a) Calculate the magnitude of Earth's magnetic field if an electron's velocity is perpendicular to the magnetic field...
-
DATABASE ALTERNATIVES a) In your own words, what do you understand by the term NOSQL databases [2 marks] b) Briefly explain the four (4) types of NOSQL databases [4 marks] 7 A BI
-
A sole proprietorship had the following assets and liabilities at the beginning and end of this year. Beginning of the year End of the year Assets $71,500 Liabilities $30,652 121,500 49,208 Determine...
-
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...
-
Given that the frequency of \(A_{3}=220 \mathrm{~Hz}\), what is the frequency of \(A_{5}\) ?
-
Briefly describe data analytics.
-
How many games would be played with 12 teams using a round-robin tournament? Compute how many games would be played in the style of tournament and number of teams given in each question. Assume all...
Study smarter with the SolutionInn App