Question

In: Accounting

Questions using the financial statements below: What is the Net Income Margin? State your answer as...

Questions using the financial statements below:

What is the Net Income Margin? State your answer as a % and round to the nearest whole number

What is the current ratio? Remember that a ratio is stated in reference to 1 (not as a percentage), and you should carry ratio out to two decimal places

What is the exact amount that account receivables increased during the year?

What is the total Cost of Sales for the year?

What month does the fiscal year begin in?

What is the quick ratio? Remember that a ratio is stated in reference to 1 (not as a percentage), and you should carry ratio out to two decimal places.

What two revenue line items make up more than 80% of the company’s revenue for the year? Hint: Write answers exactly like they are on the financial statements, capitalization and spaces included. Place a comma and space ", " in between your two answers.

How much did Park Systems invest in radio facilities?

What is EBITDA (Net Income before Interest Expense, Taxes, Depreciation and Amortization are deducted)?

How much did the company pay down its Note Payable?

Balance Sheet

Years Ended December 31 (in thousands)

Assets

Current Assets

Cash

$            23,283

Accounts Receivable, net

38,316

Prepaid Expenses

3,655

SIM Inventory

6,881

Total Current Assets

72,135

Long-Term Assets

Property & Equipment, net

462,602

Total Assets

$          534,737

Liabilities and Equity

Current Liabilities

Accounts Payable

$            14,807

Accrued Payroll

5,863

Accrued Expenses

14,659

Note Payable, current

26,972

Total Current Liabilities

62,301

Long-Term Liabilities

Note Payable, non-current

296,849

Total Liabilities

359,150

Stockholders Equity

Common Stock

134

Retained Earnings

175,453

Total Stockholders Equity

175,587

Total Liabilities & Stockholders Equity

$          534,737

Income Statement Years Ended December 31

(in thousands)

Revenues

Data

$          201,663

SIM Subscription

120,998

SMS (texting)

40,333

SIM Purchase & Activation

19,113

Other Revenue

1,053

Total Revenues

383,160

Cost of Sales

GSM Roaming & Local Data

110,915

Carrier SMS Fees

24,200

SIM Manufacturing

8,601

Direct Labor

19,158

Total Cost of Sales

162,873

Gross Profit

220,287

Operating Expenses

Core Telecom Network Ops

66,086

Sales and Marketing

32,575

Research and Development

9,772

Radio Tower Facilities

4,886

General & Administrative

65,149

Total Operating Expenses

178,468

Operating Income

41,818

Investment Income

1,685

Interest Expense

(9,715)

Foreign Exchange Gain (Loss)

(1,836)

Tax Provision Expense

(3,904)

Other Income (Expense)

1,051

Net Income

$            29,100

Statement of Cash Flows Year Ended December 31 (in thousands)

Operating Activities

Consolidated net income

$            29,100

Adjustments

Depreciation and amortization

4,819

Changes in assets and liabilities: Accounts receivable

(3,483)

Inventory

(9,891)

Accounts payable

888

Accrued expenses

20,670

Net cash provided by operating activities

42,103

Investing Activities

Investment in radio facilities

(17,102)

Capital Equipment expenditure

(5,783)

Net cash (used in) investing activities

(22,884)

Financing Activities

Payments on note payable

(6,476)

Net cash provided by financing activities

(6,476)

Net increase (decrease) in cash and equivalents

12,743

Cash and equivalents, beginning of year

10,540

Cash and equivalents, end of year

$            23,283

Solutions

Expert Solution

Net Income                 29,100
Revenue             3,83,160
Net Margin ratio 7.59%
Current Assets                 72,135
Less Current Liabilities                 62,301
Current Ratio 1.16

Accounts receivable increased during the year is $ 3483

Total cost of sales 162873

Fiscal year begins in January

Liquid Assets                 62,139
Current Liabilities                 62,301
Quick Ratio                      1.00

Data and Sim subscriptions accounts for more than 80% of the total revenue.

17,102 is the investement in radio facility.

EBITDA is 43634 (29100+4819+9715)

6476 is paid down to its note payable


Related Solutions

COMPANY STARBUCKS Using the financial statements, answer the following questions: Look at the income statement and...
COMPANY STARBUCKS Using the financial statements, answer the following questions: Look at the income statement and comment on the company’s profitability. What is basic earnings per share? It may be listed on the income statement itself, or you might have to calculate it. Look at the balance sheet. Calculate the current ratio and comment on the company’s liquidity. Calculate the debt-to-total-assets ratio and comment on the company’s solvency. Look at the statement of cash flows Comment on the results of...
II. Below are the financial statements for Trust Inc. Use the statements to answer the questions...
II. Below are the financial statements for Trust Inc. Use the statements to answer the questions that follow (8 Points) Balance Sheet (Millions of $) Assets Cash 1,050 Accounts receivable 4,830 Inventories 6,450 Net plant and equipment 8,670 Total assets 21,000 Liabilities and Equity Accounts payable 4,000 Notes payable 2,950 Accruals 2,300 Long-term bonds 5450 Common stock 1,680 Retained earnings 4,620 Total liabilities and equity 21,000 Income Statement (Millions of $) Net sales 29,400 Operating costs 27,500 Depreciation 515 Interest...
II. Below are the financial statements for Trust Inc. Use the statements to answer the questions...
II. Below are the financial statements for Trust Inc. Use the statements to answer the questions that follow (8 Points) Balance Sheet (Millions of $) Assets Cash 1,050 Accounts receivable 4,830 Inventories 6,450 Net plant and equipment 8,670 Total assets 21,000 Liabilities and Equity Accounts payable 4,000 Notes payable 2,950 Accruals 2,300 Long-term bonds 5450 Common stock 1,680 Retained earnings 4,620 Total liabilities and equity 21,000 Income Statement (Millions of $) Net sales 29,400 Operating costs 27,500 Depreciation 515 Interest...
For questions below, assume that a corporation’s pretax net income is taxable (Federal + State) based...
For questions below, assume that a corporation’s pretax net income is taxable (Federal + State) based on 21% of the first $300,000, 30% of the next $400,000, and 34% of anything beyond that. PLEASE SHOW ALL CALCULATIONS TO EARN CREDIT: If the company made $1,000,000, what is the corporation’s average tax rate? If the company made $800,000, what is the corporation’s marginal tax rate?
Explain the interrelationship of the financial statements. Specifically answer these questions: How are the income statement...
Explain the interrelationship of the financial statements. Specifically answer these questions: How are the income statement and balance sheet related to each other? Does the statement of cash flow use information from both the balance sheet and income statement? Describe how the cash flow statement is generated from Sage.
Use the pro forma financial statements to answer the questions below. Change the assumptions in the...
Use the pro forma financial statements to answer the questions below. Change the assumptions in the assumptions box as needed to answer the questions. In addition to the assumptions listed on the spreadsheet, also assume that all asset accounts will grow at the same rate as sales and that no new equity will be issued in 2018. 1. Enter a formula for external funding required in the first green box. How much external financing does Ottawa need in 2018? 2....
You should answer all of the questions listed below as they relate to the financial statements...
You should answer all of the questions listed below as they relate to the financial statements of any U.S. public company of your choice in its latest annual report. Please use the Securities and Exchange Commission web site as your primary source for financial statements. All publicly traded U S companies have their annual reports called the 10-K available through the Securities and Exchange Commission web site. http://www.sec.gov/ COMPANY: Delta Airlines Inc. (DAL) Instructions for use of the site are...
What is purpose of each of the financial statement below; support your answer with example Income...
What is purpose of each of the financial statement below; support your answer with example Income statement Returned Earning statement Balance sheet Cash flow statement
. Using the financial statement and data below answer the following questions: Financial Statement Data and...
. Using the financial statement and data below answer the following questions: Financial Statement Data and Stock Price Data for Flextronics (All data as of fiscal year end; $ in millions) Income Statement 2012 2013 2014 2015 2016 Revenue 404.3 363.8 424.6 510.7 604.1 Cost of Goods Sold -188.3 -173.8 -206.2 -246.8 -293.4 Gross profit 216 190 218.4 263.9 310.7 Sales and Marketing -66.7 -66.4 -82.8 -102.1 -120.8 Administration -60.6 -59.1 -59.4 -66.4 -78.5 Depreciation & Amortization -27.3 -27 -34.3...
State whether the statements below are true or false and explain your answer in detail. If...
State whether the statements below are true or false and explain your answer in detail. If you are uncertain, make sure that you explain why. In the classical model, the rate of interest is determined by the investment and the saving functions. However, in the Keynesian model, the rate of interest is determined by the equality of aggregate output (GDP) with aggregate expenditure (Y=C+I+G).
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT