Daks Cowboys Emporium Current Year:Sales: $$276,000$Total Costs $($COGS & Admin.$)$ $$224,000$Common Stock & Paid$-$in Capital: $20,000$Retained Earnings: $$470,160$Dividends Paid: $$16,800$Accounts Payable: $$10,400$Notes payable: $$22,800$Long$-$Term Debt: $$112,000$Net Income: $$41,080$Cash: $$12,560$Accounts Receivable: $$16,800$Inventory: $$26,000$Net plant and equipment: $$580,000$Tax Rate: $21\%$

$1.$ Construct a balance sheet with the excel formulas on how to calculate them with these figures. And find the total liabilities

$2.$ Find Pro forma income statement $-$ Sales $-$ Costs $-$ Taxable income $-$ Taxes $-$ Net income $-$ dividends$-$ Add. To Ret. Earnings

$3.$ Find Financial Ratios $-$ payout ratio $-$ plowback ratio $-$ TAT $-$ Profit margin$-$ debt$-$equity ratio $-$ ROA $-$ ROE $-$ substantial growth rate $-$ internal growth rate

$4.$ Pro forma balance sheet

$5.$ Growth in assets $-$ Internal Equity Financing $-$ External Financing Needed $-$ External Debt Needed

$6.$ New dividends $-$ new payout ratio $-$ New SGR