Question

In: Finance

Below are the past two years of financials for Field of Dreams, LLC: INCOME STATEMENT: 2016...

Below are the past two years of financials for Field of Dreams, LLC:

INCOME STATEMENT:

2016 2017
Sales $100,000.00 $138,600.00
Cost of Goods Sold $60,000.00 $83,160.00
Gross Margin $40,000.00 $55,440.00
Depreciation $16,000.00 $19,200.00
Administrative Costs $9,000.00 $10,800.00
EBIT $15,000.00 $25,440.00
Interest $4,000.00 $4,000.00
Pre-tax income $11,000.00 $21,440.00
Taxes $4,400.00 $8,576.00
Net Income $6,600.00 $12,864.00
Dividends $0.00 $7,718.40
Addition to Retained Earnings $6,600.00 $5,145.60

BALANCE SHEET AS OF 12/31/2017:

ASSETS 2016 2017
Cash $5,000.00 $6,000.00
Inventory $15,000.00 $18,000.00
Accounts Receivable $15,000.00 $20,790.00
Current Assets $35,000.00 $44,790.00
Net PPE $80,000.00 $92,000.00
Total Assets (TA) $115,000.00 $136,790.00

LIABILITIES & SHAREHOLDER EQUITY 2016 2017
Accounts Payable $25,000.00 $30,000.00
Current Liabilities $25,000.00 $30,000.00
Long Term Debt $40,000.00 $51,644.40
Total Liabilities $65,000.00 $81,644.40
Shareholder Equity $50,000.00 $55,145.60
Total Liabilities and Shareholder Equity $115,000.00 $136,790.00

What is the net increase in cash and marketable securities for 2017? (Refer to the Statement of Cash Flows)

Solutions

Expert Solution

Field of Dreams, LLC

Statement of Cash Flows

For the year ended December 31, 2017

Amount ($)

Cash flows from operating activities;

Net Income

12,864

Adjustments to reconcile net income to Net cash provided by operating activities

Depreciation Expenses

19,200

Increase in Merchandise inventories

-3,000

Increase in Accounts Receivables

-5,790

Increase in Accounts Payable

5,000

15,410

Net cash provided by operating activities

Cash flows from investing activities:

Cash payment to purchase of Equipment

-31,200

Net cash used by investing activities [$92,000 + $19,200 - $80,000]

-31,200

Cash flows from financing activities:

Cash payment on long-term Debt

11,644.40

Payment of Dividend

-7,718.40

Net cash provided by financing activities

3,926

Net increase in cash and marketable securities

$1,000

“Therefore, the net increase in cash and marketable securities for 2017 = $1,000”


Related Solutions

How would you interpret the below financials? Income Statement - Quarter 3       Gross Revenue...
How would you interpret the below financials? Income Statement - Quarter 3       Gross Revenue    3,182,084 100.0% - Commissions       285,359    9.0% - Refunds       187,743    5.9% + Interest Income                  -      0.0% Net Revenue       2,708,982 85.1%       Flight Operations       646,112    20.3% Fuel       573,887    18.0% Maintenance       565,530    17.8% Passenger Service       443,330    13.9% Cabin/Food Service         45,478    1.4% Insurance         66,000    2.1% Marketing...
How would you interpret the below financials? Income Statement - Quarter 4       Gross Revenue...
How would you interpret the below financials? Income Statement - Quarter 4       Gross Revenue    3,149,864    100.0% - Commissions       282,397    9.0% - Refunds       239,389    7.6% + Interest Income                  -      0.0% Net Revenue       2,628,078 83.4%       Flight Operations       641,849    20.4% Fuel       593,729    18.8% Maintenance       561,836    17.8% Passenger Service       430,489    13.7% Cabin/Food Service         38,562    1.2% Insurance         66,000    2.1%...
Using the income statement from Folder Factory Financials Folder Factory Financials , prepare a pro forma...
Using the income statement from Folder Factory Financials Folder Factory Financials , prepare a pro forma income statement for 2016 if the company projects sales to be $60,000 in 2016. Balance Sheet Folder Factory, Inc. December 31, 2014 and 2015 2015 2014 Assets Cash $ 1,000 $     500 Accounts receivable 5,000 4,500 Inventory 7,000 6,000 Total current assets $13,000 $11,000 Gross fixed assets $20,000 $15,000 Less: Accumulated depreciation 10,000     9,000 Net fixed assets $10,000 $ 6,000 Total assets $23,000...
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2016 Income Statement...
Graffiti Advertising, Inc., reported the following financial statements for the last two years. 2016 Income Statement Sales $ 568,700 Costs of goods sold 273,990 Selling and administrative 124,726 Depreciation 54,569 EBIT $ 115,415 Interest 19,450 EBT $ 95,965 Taxes 38,386 Net income $ 57,579 Dividends $ 10,300 Addition to retained earnings $ 47,279 GRAFFITI ADVERTISING, INC. Balance Sheet as of December 31, 2015 Cash $ 13,390 Accounts payable $ 9,497 Accounts receivable 18,987 Notes payable 14,501 Inventory 13,801 Current liabilities...
The company has been growing steadily over the past 5 years, and the financials and future...
The company has been growing steadily over the past 5 years, and the financials and future prospects look good. Your CEO has asked you to run the numbers. After doing some digging into the business, you have gathered information on the following: • The estimated purchase price for the equipment required to move the operation in-house would be $750,000. Additional net working capital to support production (in the form of cash used in Inventory, AR net of AP) would be...
The company has been growing steadily over the past 5 years, and the financials and future...
The company has been growing steadily over the past 5 years, and the financials and future prospects look good. Your CEO has asked you to run the numbers. After doing some digging into the business, you have gathered information on the following: The estimated purchase price for the equipment required to move the operation in-house would be $750,000. Additional net working capital to support production (in the form of cash used in Inventory, AR net of AP) would be needed...
The company has been growing steadily over the past 5 years, and the financials and future...
The company has been growing steadily over the past 5 years, and the financials and future prospects look good. Your CEO has asked you to run the numbers. After doing some digging into the business, you have gathered information on the following: The estimated purchase price for the equipment required to move the operation in-house would be $750,000. Additional net working capital to support production (in the form of cash used in Inventory, AR net of AP) would be needed...
The income statement of XYZ Company for the 2016 financial year was below expectations be low...
The income statement of XYZ Company for the 2016 financial year was below expectations be low Financia l Item Total in TZS Sales (40,000 units) 400,000,000 Cost of raw materials 80,000,000 Other variable costs 100,000,000 Fixed factory overheads 160,000,000 Fixed administrative overheads 30,000,000 Sales commission (3% sales value) 12,000,000 Variable delivery costs 20,000,000 Other fixed costs 30,000,000 a) What is the break-even point of the company? b) The company proposes to reduce the selling price per unit by 10% and...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years...
Horizontal Analysis of the Income Statement Income statement data for Winthrop Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $925,000 $740,000 Cost of goods sold 780,800 640,000 Gross profit $144,200 $100,000 Selling expenses $41,400 $36,000 Administrative expenses 36,900 30,000 Total operating expenses $78,300 $66,000 Income before income tax $65,900 $34,000 Income tax expenses 26,400 13,600 Net income $39,500 $20,400 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
Horizontal Analysis of the Income Statement Income statement data for Boone Company for two recent years...
Horizontal Analysis of the Income Statement Income statement data for Boone Company for two recent years ended December 31, are as follows:     Current Year     Previous Year Sales $546,000 $420,000 Cost of goods sold 473,600 370,000 Gross profit $72,400 $50,000 Selling expenses $21,600 $18,000 Administrative expenses 19,200 15,000 Total operating expenses $40,800 $33,000 Income before income tax $31,600 $17,000 Income tax expenses 12,600 6,800 Net income $19,000 $10,200 a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT