Based upon your financial forecast for the years 2023 - 2027, compute the following ratios, placing your final results in the yellow highlighted area: Industry Averages20232024202520262027 aProfit Margin12.20% bROA 8.75% cROE 22.42% dCurrent ratio2.33X eQuick ratio1.45X fDebt-to-Total Assets43.05% gTimes Interest Earned10.28X (HINT: Enter Interest Expense as a positive number for TIE) 215 points:5 for showing work, 10 for accuracy Compute Required New Funds (RNF) for each year (HINT: See Formula 4-1 in your Week 3 Chapter readings) OPTIONAL: It would be very helpful to fill out the table below identifying the necessary variables before attempting to compute RNF. 20232024202520262027 A/S = Total Current Assets/Sales S = Current Sales - Last year's Sales L/S = Total Current Liabilities/Sales P = Profit Margin (see 1a above!) S2 = Sales in the current yr D = Dividend Payout Ratio = Dividends paid/Net Income (see Assumptions)

This is the financial forecast:

Proforma Income Statement 20202021202220232024202520262027 Sales (all on credit) 1,200,000 1,500,000 1,875,000 5,625,000 7,031,250 8,789,063 10,986,328 13,732,910 Cost of Goods Sold (800,000)(1,040,000)(1,105,000)3,093,750 3,867,188 4,833,984 6,042,480 7,553,101 Gross Profit 400,000 460,000 770,000 8,718,750 10,898,438 13,623,047 17,028,809 21,286,011 Selling and Administrative Expense(224,900)(270,500)(363,700)(1,053,231)(1,316,539)(1,645,674)(2,057,092)(2,571,365)Rent Expense (15,000)(15,000)(15,000)(200,000)(200,000)(200,000)(200,000)(200,000)Depreciation Expense(65,000)(76,500)(139,000)(214,000)(214,000)(214,000)(214,000)(214,000)Operating profit (EBIT)95,100 98,000 252,300 7,251,519 9,167,898 11,563,373 14,557,716 18,300,645 Interest expense (35,000)(45,000)(85,000)(60,390)(50,390)(40,390)(30,390)(20,390)Net Income before Taxes60,100 53,000 167,300 7,191,129 9,117,508 11,522,983 14,527,326 18,280,255 Taxes (36,900)(49,200)(55,600)(2,588,806)(3,282,303)(4,148,274)(5,229,837)(6,580,892)Net Income 23,200 3,800 111,700 4,602,322 5,835,205 7,374,709 9,297,489 11,699,363 Shares 60,000 60,000 78,000 104,000 104,000 104,000 104,000 104,000 Earnings per Share $0.39$0.26$2.38$44.25$56.11$70.91$89.40$112.49 Forecasted Balance Sheet (30 points: 5 for showing work, 25 for accuracy) DURA-CLEAR WINDOWS, LLCProforma Balance Sheet 20202021202220232024202520262027ASSETS Cash 30,000 40,000 30,000 50,000 50,000 50,000 50,000 50,000 Marketable Securities20,00025,00030,00030,00030,00030,00030,00030,000Accounts Receivable 170,000259,000360,000934,4551,168,0681,460,0851,825,1072,281,383Inventory 230,000261,000290,000968,1561,210,1961,512,7441,890,9302,363,663 Total Current Assets:450,000585,000710,0001,982,6112,458,2643,052,8303,796,0374,725,046Plant and equipment650,000765,0001,390,0002,140,0002,140,0002,140,0002,140,0002,140,000Less: accumulated depreciation(65,000)(141,500)(280,500)(214,000)(214,000)(214,000)(214,000)(214,000)Net Plant and equipment585,000623,5001,109,5001,926,0001,926,0001,926,0001,926,0001,926,000Total Assets 1,035,0001,208,5001,819,5003,908,6114,384,2644,978,8305,722,0376,651,046 LIABILITIES & STOCKHOLDER'S EQUITY Accounts Payable 200,000310,000505,0001,171,4921,452,5471,803,8662,243,0152,791,951Accrued Expenses 20,40030,00035,000104,375130,469163,086203,857254,822 Total Current Liabilities220,400340,000540,0001,275,8671,583,0161,966,9522,446,8723,046,772Long-term Liabilities 325,000363,600703,900603,900503,900403,900303,900203,900 Total Liabilities545,400703,6001,243,9001,879,7672,086,9162,370,8522,750,7723,250,672Common Stock ($1 par)60,00060,00078,000104,000104,000104,000104,000104,000Capital paid in excess of par190,000190,000262,0001,236,0001,236,0001,236,0001,236,0001,236,000Retained Earnings 239,600254,900235,600688,844957,3481,267,9781,631,2652,060,374 Total Stockholder's Equity489,600504,900575,6002,028,8442,297,3482,607,9782,971,2653,400,374Total Liabilities & Stockholder's Equity1,035,0001,208,5001,819,5003,908,6114,384,2644,978,8305,722,0376,651,046