Question: Consider the pro forma & actual financial statements below for MQ Software (MQ): 1. What is MQs projected Cash Build for 2018? 2.What is MQs

Consider the pro forma & actual financial statements below for MQ Software (MQ):

Consider the pro forma & actual financial statements below for MQ Software

1. What is MQs projected Cash Build for 2018?

2.What is MQs projected Cash Burn for 2018?

3.Prepare MQs proforma Statement of Cash Flows for 2017. (Make sure you reconcile the beginning and ending cash balances)

4.What is the Companys EBITDA Breakeven in 2018?

5.What Degree of Operating Leverage (DOL) is imputed in MQs Operating Expense structure for 2018 at the projected Sales level of 600? (remember that Sales could be 600; 6,000; 6,000,000, or 60,000,000)

6.If Sales INCREASE by 20%; what would 2018 projected EBITDA be?

2018 Income Statement ected Net sales Less: CGS Gross Profit Less: Fixed SGA EBITDA Less: Depreciation EBIT Less: Interest exp EBT Less: Taxes @ 40% Net Income 300 300 240 190 150 2017 Balance Sheet (actual Cash Accounts payable & Total current liabilities Accounts receivable 120 50 Inventory Total current assets 260 1,000 800 Long-term debt 620 Gross fixed assets Accumulated depreciation Net fixed assets Total Common stock Retained earnings Total Total 100 290 390 1,060 1,060 2018 Balance Sheet (proiected Cash 30 Accounts payable & Total current liabilities Accounts Receivable 130 150 Inventory Total current assets 370 Long-term debt Gross fixed assets Accumulated depreciation Net fixed assets Total Common stock Retained earnings Total Total 110 1,120 250 870 1,240 490 1,240

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!