If possible show formulas please.

PROBLEM # 1 Macaracachimba, LLC needs to prepare pro-forma income statement for the natural year 2019, the firm's Income Statement and Balance Sheet for the year ended 31 DEC2018 are presented below Assumptions for the calendar year 2019: 1. Sales are projected to increase by 15% 2. Dividends in the amount of $750,000 will be paid to stockholders 3. A minimum cash balance of $650,000 is desired 4. A brand-new machinery will be purchased at a price of $50,000 5. Depreciation expense for the year is expected to be $50,000 6. Marketable securities will remain the same 7. Accounts receivable, inventory, accounts payable, notes payable, and accrued expenses are expected to increase in tandem with sales 8. Bonds with a market price of $30,000 will be issued 9. No new stock will be issued. Income Statement Macaracachimba, LLC For the Year Ended 31 DEC2018 $3028,500 Sales Revenue Less: Cost of Goods Sold FIxed Costs $1,350,000 $1,260,600 Variable Costs $ 417900 Gross Profits Less: Operating Expenses Fixed Expenses Variable Expenses IT (NO) Less: Interest Expense Net Profit Before Taxes (EBT) Less: Taxes (40 % ) Net Profit After Taxes (EAT or NI) S 4,500 S 85,840 $ 327,560 82150 245410 98,164 147246 Less: Dividends S 50,000 97246 Increase/Decrease in Retained Eamings S Balance Sheet Macaracachimba, LLC Asol31DEC2018 ASSETS Current Assets 625000 298.000 580,000 Cash & Cash Equivalents Marketable Securities Accounts Receivable $ Inventories 496000 Total Current Assets $1,999.000 Long-Term Assets Land & Buildings Machinery & Equipment $625.000 $765.000 $110000 Fumitures & Fixtures $ 1.500,000 Total Gross Foed Assets Less: Accumulated Depreciation 30000 Net Fixed Assets 1,470,000 Total Assets $3,469,000 $(1.999,000) Net Profit After Taxes (EAT or NI) LIABLMES Current Liabilities Accounts Payable Notes Payable Accrued Expenses 267.000 S 135,000 288,000 690000 Total Current Liabilities Long-Term Lijabilities Total Long-Term Debt 1,200,000 Total Liabilities $1,890,000 STOCKHOLDERSEQUTY 79000 Preferred Stock Common Stock Paid-in Capital Retained Eamnings 750,000 601,000 $ 149,000 Total Stockholders Equity $1,579,000 TOTALLIABUTES&STOCKHOLDERSEQUITY 3,469,000