Question

In: Finance

1. What is the exact amount that account receivables increased during the year? Hint: Use the...

1. What is the exact amount that account receivables increased during the year? Hint: Use the Statement of Cash Flow.

2. What is the total Cost of Sales for the year?

3. How much did Park Systems invest in radio facilities?

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

5. How much did the company pay down its Note Payable?

Park Systems
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

Park Systems
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

Park Systems
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

Part 1)

The exact amount by which accounts receivables increased during the year is $3,483 (in thousands) or $3,483,000 [refer to operating activities section of the statement of cash flows].

____

Explanation:

In statement of cash flows, an increase in current assets (such as accounts receivable, inventory, etc.) is reported as a negative amount. Therefore, a negative value of accounts receivable indicates an increase in its value during the year with an amount of $3,483 (in thousands).

_____

Part 2)

Total Cost of Sales for the year is $162,873 (in thousands) or $16,2873,000 [refer to income statement].

_____

Part 3)

The amount invested by Park Systems in radio facilities is $17,102 (in thousands) or $17,102,000 [refer to investing activities section of the statement of cash flows].

____

Explanation:

In statement of cash flows, purchase of fixed assets or long term investments (such as investment in plant, machinery, equipment, etc.) is reported as a negative amount under the cash flow from investing activities. Therefore, a negative amount of $17,102 (in thousands) indicates that the company has invested this amount in radio facilities.

_____

Part 4)

The value of EBITDA (Net Income before Interest Expense, Taxes, Depreciation and Amortization are deducted) is calculated as follows:

EBITDA = Operating Income (from Income Statement) + Depreciation and Amortization Expense (from Statement of Cash Flows) = 41,818 + 4,819 = $46,637 (in thousands) or $46,637,000

_____

Part 5)

The amount paid by the company on its note payable is $6,476 (in thousands) or $6,476,000 [refer to financing activities section of the statement of cash flows].

____

Explanation:

In statement of cash flows, any amount paid by the company towards its long term debt (such as note payable, long term loan, bonds payable, etc.) is reported as a negative amount under the cash flow from financing activities. Therefore, a negative value of $6,476 (in thousands) indicate that the company has paid this much amount on its note payable.


Related Solutions

QUESTION 1. A company's accounts receivable increased during the year by $6 million. What is the...
QUESTION 1. A company's accounts receivable increased during the year by $6 million. What is the amount of cash the company received from customers during the reporting period if its sales were $50 million? QUESTION 2. A company's inventory increased during the year by $7 million. Its accounts payable increased by 9 million during the same period. What is the amount of cash paid to suppliers of merchandise during the reporting period if its cost of goods sold was $35...
XYZ has cash flow from operating activities of $40,000. If accruals increased by $20,000, account receivables...
XYZ has cash flow from operating activities of $40,000. If accruals increased by $20,000, account receivables increased by $90,000, and deprecation expenses totaled of $15,000. What was the company net income? a. $95,000 b. $120,000 c. -$75,000 d. -$100,000
1. What are key steps in conducting the money market hedge for account receivables? 2. What...
1. What are key steps in conducting the money market hedge for account receivables? 2. What are key steps in conducting the money market hedge for account  payables?
1. A possible liability is a liability that is known to exist but the exact amount...
1. A possible liability is a liability that is known to exist but the exact amount is unknown. Select one: True False 2. Obligations that must be repaid within one year or the operating cycle, whichever is shorter, are called current liabilities. Select one: True False Points out of 5.00 3. Net pay equals gross pay less applicable payroll taxes and worker's compensation insurance. Select one: True False 4. The withholding of taxes from an employee's pay is recorded as...
TJ Enterprises’ equipment account increased $43,000 during the period; the related accumulated depreciation increased $14,000. New...
TJ Enterprises’ equipment account increased $43,000 during the period; the related accumulated depreciation increased $14,000. New equipment was purchased at a cost of $58,000 and used equipment was sold at a loss of $4,000. Depreciation expense was $19,000. How much is proceeds from the sale of the used equipment? a. $10,000 b. $15,000 c. $6,000 d. $14,000
QUESTION 1) (20 pts) The amount of allowance for accounts receivable increased from the prior year,...
QUESTION 1) (20 pts) The amount of allowance for accounts receivable increased from the prior year, but the allowance as a percentage of accounts receivable decreased from the prior year. Total bank loans increased from the prior year, but total interest expense decreased as a percentage of bank loans. REQUIRED: Evaluate the potential significance of each of the changes in ratios or trends identified in your analysis on the fair presentation of financial statements. As an auditor do you see...
Question 1 If accounts receivable increased from $12,000 to $15,000 during the year and if sales...
Question 1 If accounts receivable increased from $12,000 to $15,000 during the year and if sales amounted to $100,000 for the year, cash receipts from customers amounted to $103,000. A. True B. False                           Question 2 When net income is used as a starting point in measuring cash flows from operating activities, there is no need to add depreciation expense to net income. A. True B. False Question 3 What is the acid-test ratio for the following data? Cash - $34,000;...
The cost of goods sold during the year was $281200. Inventory increased by $9000 during the...
The cost of goods sold during the year was $281200. Inventory increased by $9000 during the year and accounts payable decreased by $14100 during the year. Using the direct method of reporting cash flows from operating activities, cash payments for inventory total $295300. $304300.
What total amount should be reported as current trade and other receivables?
Valiant Company reported the following analysis of current receivables at year-end:Trade accounts receivable2,000,000Allowance for doubtful accounts(100,000)Claim against shipper for goods lost in transit in November300,000Selling price of unsold goods sent by valiant on consignment at 150% of cost and not included in ending inventory600,000Security deposit on lease of warehouse200,000Total3,000,000What total amount should be reported as current trade and other receivables?
USE PYTHON 4.15 LAB: Exact change Write a program with total change amount as an integer...
USE PYTHON 4.15 LAB: Exact change Write a program with total change amount as an integer input, and output the change using the fewest coins, one coin type per line. The coin types are Dollars, Quarters, Dimes, Nickels, and Pennies. Use singular and plural coin names as appropriate, like 1 Penny vs. 2 Pennies. Ex: If the input is: 0 (or less than 0), the output is: No change Ex: If the input is: 45 the output is: 1 Quarter...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT