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...
-
Using source transformation, find Io in the circuit in figure. 8 kn 2 kn 2 mA 1 mA ww 3 kn 6 kn3
-
The following stacked time traces from four separate motors identify one as experiencing impacts in the ball bearing. What is the separation in the impacts in this time waveform? Acceleration in G-s...
-
Presented here are the amounts of Assets, Liabilities, Stockholders Equity, Revenues, and Expenses of Camp Out, Inc., at October 31,2011. The items are listed in alphabetical order. The retained...
-
How would each of the following changes tend to affect aggregate payout ratios (that is, the average for all corporations), other things held constant? Explain your answers. a. An increase in the...
-
B-1 (10 MARKS) The MS Manufacturing Company in Mexico borrowed $100,000 US from the Bank of America; the loan carried an interest rate of 12% and the exchange rate at the time the funds were advanced...
-
The production manager at a factory manufacturing four types of light fittings (A, B, C and D) on an automated machine is fixing the schedule for the next week on this machine. HEIJUNKA SCHEDULING OF...
-
Sales records of a supermarket show that the expenditures of customers during each visit at the supermarket are normally distributed with a mean of $112 and a standard deviation of $36. (a) Find the...
-
Activity Overview Y ou will do a stakeholder analysis and power grid. As a project manager, it's important to understand how each stakeholder relates to your project. Completing a stakeholder...
-
A hungry 850 N bear walks out on a beam in an attempt to retrieve some "goodies" hanging at the end (Fig. P8.20). The beam is uniform, weighs 250 N, and is 6.00 m long; the goodies weigh 85.0 N. 60.0...
-
Kmeciak Corp. incurs unit costs of $6.20 ($5.10 variable and $1.10 fixed) in making a gear for its finished product. A supplier offers to make 8,300 of the assembly part at $5.30 per unit. If the...
-
An "incident" of potentially great international importance occurred involving the Saudi Arabian consulate in Turkey this past week. First, identify what is alleged to have occurred, who it involved,...
-
Express the matrix A and its inverse A-1 as a product of elementary matrices. 1 3 0) A=0 0 5 3 10 0
-
What is the total interest paid over the life of a $245,000 30 year loan with Principal and interest payment of $1,171 per month and a loan factor of 4.78 with an interest rate of 4%?
-
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...
-
Burgers \& Fries, Inc., is authorized to issue an unlimited number of common shares and 10,000 preferred shares. During its first year, the business completed the following share issuance...
-
Citadel Sporting Goods is authorized to issue 5,000 preferred shares and 10,000 common shares. During a two-month period, Citadel completed these share-issuance transactions: Prepare the...
-
Sagebrush Software Lid. had the following selected account balances at December 31, 2020 (in thousands). Prepare the shareholders' equity section of Sagebrush Software's balance sheet (in thousands)....
Study smarter with the SolutionInn App