Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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):

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Audit Quality Developing A Quality Assurance And Improvement Program

Authors: Sally-Anne Pitt

1st Edition

1118715519, 978-1118715512

More Books

Students also viewed these Accounting questions

Question

5. Recognize your ability to repair and let go of painful conflict

Answered: 1 week ago