Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Forecast the financial statements for Q9 Networks Inc. for Year 6 based on the Year 5 historic financial statements and the assumptions listed below. Then

Forecast the financial statements for Q9 Networks Inc. for Year 6 based on the Year 5 historic financial statements and the assumptions listed below. Then answer the questions that follow.

1. Sales growth = 20%

2. Cost of debt = 4 %

3. Tax rate = 35%

4. Depreciation rate = 5%

5. CAPEX = $4,000,000

6. Accounts held constant: prepaid expenses, short-term debt, long-term debt, common stock

7. Cash is the plug account.

8. No dividends

In the event that taxable income is negative, please calculate taxes in the usual way. Negative taxes can be thought of as a refund.image text in transcribed

image text in transcribed

Part 1: What is the depreciation expense in Year 6?

Part 2: What is the interest expense in Year 6?

Year 5 Ratios Year 6 Revenue 37,829.0 Operating Expenses: Cost of Goods Sold 25,840.0 0.683074 SG&A 11,163.0 0.295091 Depreciation Expense 535.0 Total Operating Expenses 37,538.0 EBIT 291.0 Interest Expense 304.2 Earnings Before Taxes -13.2 Provision for Income Taxes -4.6 Net Income -8.6 ASSETS Year 5 Ratios Year 6 Cash 71,192.0 Accounts Receivable 3,242.0 0.085701 Prepaid Expenses 1,804.0 1,804.0 Total Current Assets 76,238.0 Property, plant, & Equipment, Net 36,757.0 Total Assets 112,995.0 LIABILITIES & STOCKHOLDERS' EQUITY Accounts Payable 3,041.0 Short-Term Debt 4,647.0 4,647.0 Total Current Liabilities 7,688.0 Long-Term Debt 4,091.0 4,091.0 Total Liabilities 11,779.0 Shareholders' Equity Common Stock 178,328.0 178,328.0 Retained Earnings -77,112.0 Total Shareholders' Equity 101,216.0 Total Liabilities and Shareholders' Equity 112,995.0 Year 5 Ratios Year 6 Revenue 37,829.0 Operating Expenses: Cost of Goods Sold 25,840.0 0.683074 SG&A 11,163.0 0.295091 Depreciation Expense 535.0 Total Operating Expenses 37,538.0 EBIT 291.0 Interest Expense 304.2 Earnings Before Taxes -13.2 Provision for Income Taxes -4.6 Net Income -8.6 ASSETS Year 5 Ratios Year 6 Cash 71,192.0 Accounts Receivable 3,242.0 0.085701 Prepaid Expenses 1,804.0 1,804.0 Total Current Assets 76,238.0 Property, plant, & Equipment, Net 36,757.0 Total Assets 112,995.0 LIABILITIES & STOCKHOLDERS' EQUITY Accounts Payable 3,041.0 Short-Term Debt 4,647.0 4,647.0 Total Current Liabilities 7,688.0 Long-Term Debt 4,091.0 4,091.0 Total Liabilities 11,779.0 Shareholders' Equity Common Stock 178,328.0 178,328.0 Retained Earnings -77,112.0 Total Shareholders' Equity 101,216.0 Total Liabilities and Shareholders' Equity 112,995.0

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

Fundamentals Of Futures And Options Markets

Authors: John C. Hull

4th Edition

0130176028, 9780130176028

More Books

Students also viewed these Finance questions

Question

2. What is the meaning and definition of Banking?

Answered: 1 week ago

Question

3.What are the Importance / Role of Bank in Business?

Answered: 1 week ago

Question

2. Whats involved in listening?

Answered: 1 week ago

Question

1. How do listening and hearing diff er?

Answered: 1 week ago