Forecasted financial statements are given Sales (all on credit) Cost of Goods Sold Gross Profit Selling and
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Rent Expense Depreciation Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares Earnings per Share ASSETS Cash Marketable Securities Accounts Receivable. Inventory Plant and equipment Less: accumulated depreciation Net Plant and equipment Total Assets LIABILITIES & STOCKHOLDER'S EQUITY Accounts Payable Accrued Expenses Forecasted Balance Sheet (30 points: 5 for showing work, 25 for accuracy) DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet 2020 2021 Long-term Liabilities Common Stock ($1 par) Capital paid in excess of par Retained Earnings Total Current Assets: Total Current Liabilities Total Liabilities Total Stockholder's Equity DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2020 2021 Total Liabilities & Stockholder's Equity $0.39 2022 $0.26 2023 2022 1,200,000 1,500,000 1,875,000 5,625,000 7,031,250 8,789,063 10,986,328 13,732,910 (800,000) (1.040.000) (1.105.000 3.093.750 3.867.188 4.833.984 6.042.480 7.553.101 400,000 460,000 770,000 8,718,750 10,898,438 13,623,047 17,028,809 21,286,011 (224,900) (270,500) (363,700) (1,053,231) (1,316,539) (1,645,674) (2,057,092) (2,571,365) (15,000) (15,000) (15,000) (200,000) (200,000) (200,000) (200,000) (200,000) (65.000) (76.500) 1139.000) (214.000) (214.000) (214.000) 1214.000) (214,000) 95,100 98,000 252,300 7,251,519. 9,167,898 11,563,373 14,557,716 18,300,645 (85.000 (60,390) (50,390) (40,390) (30,390) (20,390) 167,300 7,191,129 9,117,508 11,522,983 14,527,326 18,280,255 155.600 12.588.806) (3.282.303) (4.148.274) (5.229.837) (6.580,8921 111,700 4,602,322 5,835,205 7,374,709 9,297,489 11,699,363 78,000 104,000 104,000 104,000 104,000 104,000 $44.25 $56.11 $70.91 $89.40 $112.49 (35,000) (45.000) 60,100 53,000 (36.900) (49,200) 23,200 3,800 60,000 60,000 $2.38 2024 2023 2024 2025 50,000 30,000 2025 2026 50,000 2026 2027 30,000 40,000 30,000 50,000 30,000 30,000 20,000 25,000 30,000 30,000 170,000 259,000 360,000 934,455 1,168,068 1,460,085 1,825,107 2,281,383 230.000 261.000 290,000 975.625 1.219.531 1.524.414 1.905.518 2.381.897 450,000 585,000 710,000 1,990,080 2,467,599 3,064,499 3,810,624 4,743,280 650,000 765,000 1,390,000 2,140,000 2,140,000 2,140,000 2,140,000 2,140,000 (65.000) (141,500) (280,500 (494,500) (708.500) (922.500) (1.136.500 (1.350.500) 585.000 623.500 1.109.500 1.645.500 1.431.500 1.217.500 1.003.500 789.500 1.035.000 1.208.500 1.819.500 3.635.580 3.899.099 4.281.999 4.814.124 5.532.780 50,000 2027 50,000 30,000 3,006,625 200,000 310,000 505,000 20.400 30,000 35,000 104.375 130,469 163,086 203.857 254.822 220,400 340,000 540,000 1,175,905 1,458,063 1,810,761 2,251,634 2,802,725 325.000 363.600 703.900 603.900 503,900 403.900 303.900 203.900 545,400 703,600 1,243,900 1,779,805 1,961,963 2,214,661 2,555,534 60,000 60,000 78,000 104,000 104,000 104,000 104,000 190,000 190,000 262,000 1,236,000 1,236,000 1,236,000 1,236,000 1,236,000 239.600 254,900 235,600 515.775 $97.136 727,338 918.590 1.186.156 489.600 504,900 575.600 1.855.775 1937.136 2.067.338 2.258.590 2.526 156 1.035.000 1.208.500 1.819.500 3.635.580 3.899.099 4.281.999 4.814.124 5.532.780 104,000 Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Rent Expense Depreciation Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares Earnings per Share ASSETS Cash Marketable Securities Accounts Receivable. Inventory Plant and equipment Less: accumulated depreciation Net Plant and equipment Total Assets LIABILITIES & STOCKHOLDER'S EQUITY Accounts Payable Accrued Expenses Forecasted Balance Sheet (30 points: 5 for showing work, 25 for accuracy) DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet 2020 2021 Long-term Liabilities Common Stock ($1 par) Capital paid in excess of par Retained Earnings Total Current Assets: Total Current Liabilities Total Liabilities Total Stockholder's Equity DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2020 2021 Total Liabilities & Stockholder's Equity $0.39 2022 $0.26 2023 2022 1,200,000 1,500,000 1,875,000 5,625,000 7,031,250 8,789,063 10,986,328 13,732,910 (800,000) (1.040.000) (1.105.000 3.093.750 3.867.188 4.833.984 6.042.480 7.553.101 400,000 460,000 770,000 8,718,750 10,898,438 13,623,047 17,028,809 21,286,011 (224,900) (270,500) (363,700) (1,053,231) (1,316,539) (1,645,674) (2,057,092) (2,571,365) (15,000) (15,000) (15,000) (200,000) (200,000) (200,000) (200,000) (200,000) (65.000) (76.500) 1139.000) (214.000) (214.000) (214.000) 1214.000) (214,000) 95,100 98,000 252,300 7,251,519. 9,167,898 11,563,373 14,557,716 18,300,645 (85.000 (60,390) (50,390) (40,390) (30,390) (20,390) 167,300 7,191,129 9,117,508 11,522,983 14,527,326 18,280,255 155.600 12.588.806) (3.282.303) (4.148.274) (5.229.837) (6.580,8921 111,700 4,602,322 5,835,205 7,374,709 9,297,489 11,699,363 78,000 104,000 104,000 104,000 104,000 104,000 $44.25 $56.11 $70.91 $89.40 $112.49 (35,000) (45.000) 60,100 53,000 (36.900) (49,200) 23,200 3,800 60,000 60,000 $2.38 2024 2023 2024 2025 50,000 30,000 2025 2026 50,000 2026 2027 30,000 40,000 30,000 50,000 30,000 30,000 20,000 25,000 30,000 30,000 170,000 259,000 360,000 934,455 1,168,068 1,460,085 1,825,107 2,281,383 230.000 261.000 290,000 975.625 1.219.531 1.524.414 1.905.518 2.381.897 450,000 585,000 710,000 1,990,080 2,467,599 3,064,499 3,810,624 4,743,280 650,000 765,000 1,390,000 2,140,000 2,140,000 2,140,000 2,140,000 2,140,000 (65.000) (141,500) (280,500 (494,500) (708.500) (922.500) (1.136.500 (1.350.500) 585.000 623.500 1.109.500 1.645.500 1.431.500 1.217.500 1.003.500 789.500 1.035.000 1.208.500 1.819.500 3.635.580 3.899.099 4.281.999 4.814.124 5.532.780 50,000 2027 50,000 30,000 3,006,625 200,000 310,000 505,000 20.400 30,000 35,000 104.375 130,469 163,086 203.857 254.822 220,400 340,000 540,000 1,175,905 1,458,063 1,810,761 2,251,634 2,802,725 325.000 363.600 703.900 603.900 503,900 403.900 303.900 203.900 545,400 703,600 1,243,900 1,779,805 1,961,963 2,214,661 2,555,534 60,000 60,000 78,000 104,000 104,000 104,000 104,000 190,000 190,000 262,000 1,236,000 1,236,000 1,236,000 1,236,000 1,236,000 239.600 254,900 235,600 515.775 $97.136 727,338 918.590 1.186.156 489.600 504,900 575.600 1.855.775 1937.136 2.067.338 2.258.590 2.526 156 1.035.000 1.208.500 1.819.500 3.635.580 3.899.099 4.281.999 4.814.124 5.532.780 104,000
Expert Answer:
Related Book For
Foundations of Financial Management
ISBN: 978-1259277160
16th edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen
Posted Date:
Students also viewed these accounting questions
-
What do we put in the term interdisciplinary team? Discuss how theories of intergroup relations can used to understand what makes such teams effective, but also what can create challenges....
-
The comparative statements of Larker Tool Company are presented below. Larker Tool Company Income Statement For the Years Ended December 31 Larker Tool Company Statements of Financial Position...
-
You have just been hired as a stock analyst for a large stock brokerage company. Your first assignment is to analyze the performance of Gidley Electronics. The companys balance sheet for 2014 and...
-
Panamint Candy Company prepared the following amortization table for $300,000 of 5-year, 9% bonds issued and sold by Panamint on January 1, 2021, for $285,000: Required: 1. Prepare the entry to...
-
Design the spring of Ex. 105 using the Gerber fatigue-failure criterion.
-
Recapture of Depreciation Deductions Due to Personal Use. Tammy acquired an automobile for $20,000 on July 1, 2016. Her business use of the vehicle is 70% in 2016, 70% in 2017,40% in 2018, and 35% in...
-
Identify organizations in your area that fit each business market category: producer, reseller, government, and institutional. Explain your classifications.
-
Two instructors announced that they "grade on the curve," that is, give a fixed percentage of each of the various letter grades to each of their classes. Their curves are as follows: If a random...
-
Identify as an increase or decrease. Then find the percent of increase or decrease. If necessary, round to the nearest tenth of a percent. Original: 110 New: 130 %Select an answer
-
Amy Lloyd is interested in leasing a new car and has contacted three automobile dealers for pricing information. Each dealer offered Amy a closed-end 36 month lease with no down payment due at the...
-
Please explain the difference roles between RTP and RTCP and explain what will happen if RTCP packets are sent too frequently.
-
Discuss how a concept you now understand related to this course content is different from what you had previously thought. Describe what your understanding was before and what it is now. Then...
-
Martingale Corporation is considering a project that requires an initial investment of $5,000 at the beginning and a net cost of $5,000 (note: this is a negative value!) in Year 1. The project is...
-
An office is considering purchasing a new IT system at a cost of $60,000 The system will result in a $45,000 improvement in yearly sales, resulting in an additional $21,000 in cost of goods sold. The...
-
2. FCF has noted that there are definite differences among their customers. Their loan application process is quick and simple, so they do not investigate customers too deeply, but they can access a...
-
7. Two students are enrolled in RMI 2101. Jessica has a 3.8 GPA and Colleen has a 2.0 GPA. Jessica has a variance of 0.5 and Colleen has a variance of 0.4 mathematically prove and identify who faces...
-
Tim, a single taxpayer, operates a business as a single-member LLC. In 2022, his LLC reports business income of $433,500 and business deductions of $758,625, resulting in a loss of $325,125. What are...
-
Which of the following streaming TV devices does not involve use of a remote controller? A) Google Chromecast B) Apple TV C) Amazon Fire TV D) Roku
-
In Problem 12, assume the term structure of interest rates becomes inverted, with short-term rates going to 11 percent and long-term rates 5 percentage points lower than short-term rates. If all...
-
In March, Hertz Pain Relievers bought a massage machine that provided a return of 8 percent. It was financed by debt costing 7 percent. In August Mr. Hertz came up with a heating compound that would...
-
Route Canal Shipping Company has the following schedule for aging of accounts receivable: a. Fill in column (4) for each month. b. If the firm had $1,500,000 in credit sales over the four-month...
-
Distinguish among the three types of responsibility
-
Using the information in E7-1, assume that in July 2002, Voss Company incurs the following manufacturing overhead costs. Instructions (a) Prepare a flexible budget performance report, assuming that...
-
Samano Company uses flexible budgets to control its selling expenses. Monthly sales are expected to range from \($170,000\) to \($200,000\). Variable costs and their percentage relationship to sales...
Study smarter with the SolutionInn App