any help with this is apprieciated.

Spilde Pharmaceuticals manufactures an academic steroid (ACTC) known to improve the brain function in MBA students. The drug is believed to be an effective treatment for students challenged by Module 2 content. Sponsler Pharmaceuticals' pro forma balance sheet for the year ending December 31, 2019, is presented below. Spilde Pharmaceuticals Balance Sheet Year Ending December 31, 2019 Cash Short-term Investments Accounts Receivable *Raw Materials Inventory "Finished Goods Inven. Equipment Accumulated Depreciation Total Assets $11,000 20,000 36,000 2,000 4,248 80,000 (6,000) $147.248 Accounts Payable Long-term Debt Total Liabilities Common Stock - $10 par Additional Paid-in Capital Retained Earnings Total Shareholders' Equity Total Liabilities & SE $3,600 50.000 $53.600 $35,000 25,000 33.648 93,648 S147.248 *Note: Raw Materials Inventory consists of 500-Ibs. at $4 per lb., and Finished Goods Inventory consists of 1,200 bottles at an average cost of $3.54 per bottle. You are required to prepare a 2020 master budget for Spilde Pharmaceuticals. THIS The master budget needs to include the following components, and should be presented in a professional format using either an Excel spreadsheet or a Word document (Excel spreadsheet will be much easier): 1. Sales budget 2. Production budget 3. Direct materials purchase budget 4. Direct labor budget 5. Manufacturing overhead budget 6. Selling and administrative expenses budget 7. Ending finished goods inventory/Cost of goods sold 8. Cash budget 9. Pro forma income statement for the year ending December 31, 2020 10. Pro forma balance sheet as of December 31, 2020 Fixed (annual basis): Depreciation: $13,320 Property taxes: $4,200 Total Unit Cost (per 1,000 pills): Raw materials (S4 x 1) $ 4.00 Direct Labor (S20 x.5) 10.00 Variable OH (S3.4 x 5 DLH) 1.70 Fixed OH 2.00 Total Unit Cost $17.70_($17.70/5 = $3.54 per bottle) Selling and Administrative expenses: the following is a breakdown of the variable and fixed selling and administrative expected costs. The company pays all selling and administrative costs in the quarter incurred. Variable (per bottle): Commission: $1.20 Freight-out: S.40 Fixed (annual basis): . Advertising: $6,000 Sales Salaries: $32,000 Office Salaries: $14,000 Depreciation: $4,000 Insurance: $7.000 Other additional information: Short-term investments are deemed worthless at the end of 2020, so the company recorded a $20,000 loss on its Income Statement. The company expects to purchase new equipment costing $50,000 cash in the third quarter of 2020 (ignore any additional depreciation expense on the new purchase). The company makes equal quarterly payments ($12,000 quarter) for its estimated annual income taxes which are expected to total $48,000 for 2020. The company has adopted the policy of a $20,000 minimum cash balance. If it needs to borrow, a revolving line of credit is available up to $100,000. The company can borrow and repay in increments of $1,000 only. The interest is due in the following quarter on any borrowings outstanding at the rate of 6% per quarter. For simplicity assume there is a quarterly interest expense of $2,000 on the long-term debt ($8,000 for the year). The company paid dividends to shareholders totaling $15,000 in the third quarter