Question

In: Accounting

A comparative balance sheet for Martinez Corporation is presented below. December 31 Assets 2017 2016 Cash...

A comparative balance sheet for Martinez Corporation is presented below.

December 31

Assets

2017

2016

Cash $  72,870 $  22,000
Accounts receivable 83,730 67,860
Inventory 181,730 190,860
Land 72,730 111,860
Equipment 261,730 201,860
Accumulated Depreciation-Equipment ( 70,730 ) ( 43,860 )
   Total $ 602,060 $ 550,580
Liabilities and Stockholders' Equity
Accounts payable $  35,730 $  48,860
Bonds payable 150,000 200,000
Common stock ($1 par) 214,000 164,000
Retained earnings 202,330 137,720
   Total $ 602,060 $ 550,580


Additional information:

1. Net income for 2017 was $ 128,460. No gains or losses were recorded in 2017.
2. Cash dividends of $ 63,850 were declared and paid.
3. Bonds payable amounting to $ 50,000 were retired through issuance of common stock.

Prepare a statement of cash flows for 2017 for Martinez Corporation. (Show amounts that decrease cash flow with either a - sign e.g. -15,000 or in parenthesis e.g. (15,000).)

MARTINEZ CORPORATION
Statement of Cash Flows

choose the accounting periodchoose the accounting period  December 31, 2017For the Year Ended December 31, 2017For the Quarter Ended December 31, 2017

select an opening name for section oneselect an opening name for section one  Cash at Beginning of YearCash at End of YearCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash Used by Financing ActivitiesNet Cash Used by Investing ActivitiesNet Cash Used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities

select an itemselect an item  Increase in InventoryDecrease in Accounts PayableIncrease in Accounts ReceivableIncrease in Accounts PayableDepreciation expensePurchase of EquipmentDecrease in InventorySale of LandNet IncomeDecrease in Accounts ReceivablePayment of Cash Dividends

$ enter a dollar amount

Adjustments to reconcile net income to

select an opening name for subsection oneselect an opening name for subsection one  Cash at Beginning of YearCash at End of YearCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash Used by Financing ActivitiesNet Cash Used by Investing ActivitiesNet Cash Used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities

select an itemselect an item  Depreciation expenseDecrease in InventoryNet IncomePayment of Cash DividendsDecrease in Accounts PayableIncrease in Accounts PayableIncrease in InventorySale of LandIncrease in Accounts ReceivableDecrease in Accounts ReceivablePurchase of Equipment

$ enter a dollar amount

select an itemselect an item  Increase in Accounts ReceivableDepreciation expenseDecrease in Accounts PayablePurchase of EquipmentIncrease in Accounts PayablePayment of Cash DividendsIncrease in InventorySale of LandDecrease in Accounts ReceivableDecrease in InventoryNet Income

enter a dollar amount

select an itemselect an item  Decrease in InventoryPurchase of EquipmentDecrease in Accounts ReceivableIncrease in Accounts PayableIncrease in InventoryIncrease in Accounts ReceivableNet IncomeSale of LandDepreciation expensePayment of Cash DividendsDecrease in Accounts Payable

enter a dollar amount

select an itemselect an item  Increase in InventoryPurchase of EquipmentIncrease in Accounts PayableDecrease in Accounts PayableDecrease in InventoryDepreciation expenseIncrease in Accounts ReceivablePayment of Cash DividendsDecrease in Accounts ReceivableSale of LandNet Income

enter a dollar amount

enter a subtotal of the four previous amounts

select a closing name for section oneselect a closing name for section one  Cash at Beginning of YearCash at End of YearCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash Used by Financing ActivitiesNet Cash Used by Investing ActivitiesNet Cash Used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities

enter a total amount for section one

select an opening name for section twoselect an opening name for section two  Cash at Beginning of YearCash at End of YearCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash Used by Financing ActivitiesNet Cash Used by Investing ActivitiesNet Cash Used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities

select an itemselect an item  Sale of LandIncrease in Accounts ReceivableDecrease in Accounts ReceivableNet IncomeDecrease in Accounts PayableIncrease in Accounts PayablePayment of Cash DividendsIncrease in InventoryDepreciation expenseDecrease in InventoryPurchase of Equipment

enter a dollar amount

select an itemselect an item  Increase in Accounts PayableDecrease in InventoryDepreciation expenseIncrease in InventorySale of LandDecrease in Accounts PayableDecrease in Accounts ReceivablePayment of Cash DividendsNet IncomePurchase of EquipmentIncrease in Accounts Receivable

enter a dollar amount

select a closing name for section twoselect a closing name for section two  Cash at Beginning of YearCash at End of YearCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash Used by Financing ActivitiesNet Cash Used by Investing ActivitiesNet Cash Used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities

enter a total amount for section two

select an opening name for section threeselect an opening name for section three  Cash at Beginning of YearCash at End of YearCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash Used by Financing ActivitiesNet Cash Used by Investing ActivitiesNet Cash Used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities

select an itemselect an item  Sale of LandIncrease in InventoryNet IncomeDecrease in Accounts PayableDecrease in InventoryDepreciation expensePayment of Cash DividendsPurchase of EquipmentDecrease in Accounts ReceivableIncrease in Accounts ReceivableIncrease in Accounts Payable

enter a dollar amount

select an itemselect an item  Cash at Beginning of YearCash at End of YearCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash Used by Financing ActivitiesNet Cash Used by Investing ActivitiesNet Cash Used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities

enter a total amount for three sections

select an itemselect an item  Cash at Beginning of YearCash at End of YearCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash Used by Financing ActivitiesNet Cash Used by Investing ActivitiesNet Cash Used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities

enter a dollar amount

select a closing name for this statementselect a closing name for this statement  Cash at Beginning of YearCash at End of YearCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash Used by Financing ActivitiesNet Cash Used by Investing ActivitiesNet Cash Used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities

$ enter a total of the two previous amounts

select an itemselect an item  Cash at Beginning of YearCash at End of YearCash Flows from Financing ActivitiesCash Flows from Investing ActivitiesCash Flows from Operating ActivitiesNet Cash Provided by Financing ActivitiesNet Cash Provided by Investing ActivitiesNet Cash Provided by Operating ActivitiesNet Cash Used by Financing ActivitiesNet Cash Used by Investing ActivitiesNet Cash Used by Operating ActivitiesNet Decrease in CashNet Increase in CashNoncash Investing and Financing Activities

      Issued common stock to retire $ enter a dollar amount  of bonds outstanding

Determine Martinez Corporation’s current cash debt coverage, cash debt coverage, and free cash flow. (Round current cash debt coverage and cash debt coverage to 2 decimal places., e.g. 0.67.)

Current cash debt coverage

enter the current cash debt coverage rounded to 2 decimal places

:1
Cash debt coverage

enter the Cash debt coverage rounded to 2 decimal places

:1
Free cash flow

$ enter a dollar amount


Comment on its liquidity and financial flexibility.

Martinez has  select an optionselect an option  poorexcellent liquidity. Its financial flexibility is  select an optionselect an option  goodbad.

Solutions

Expert Solution

1

Martinez Corporation

Cash flow statement

Particulars

Amount $

Amount $

Cash flow from operating activities

Net Income

$128,460

Add:- non cash expenses

Depreciation (70,730-43860)

$26,870

Less:- Increase in current assets (67860-83730)

-15870

Add:- Decrease in current assets (190860-18730)

9130

Add:- decrease in Account payable (35730-48,860)

-13130

Total Changes

$7,000

cash inflow from operating activities

$135,460

cash flow from Investing activities

sale of land (111860-72730)

$39,130

Purchased of equipment(201860-261730)

($59,870)

cash outflow from investing activates

($20,740)

C. cash flow from financing activities

Bond retired for issuance of common stock

($50,000)

payment of Dividend

($63,850)

Issuance of common stock

$50,000

cash outflow from financing activates

($63,850)

Net cash changes

$50,870

cash of beginning balance

$22,000

cash at ending balance

$72,870

2

Current cash
debt coverage ratio

Net cash provided by operating activities /Average current liabilities
=135460/ ( 35,730+48860)/2
=3.20

Cash debt coverage ratio

Net cash provided by operating activities /Average total liabilitie
=135460/ ( 185730+248860)/2
=0.62

               

Net cash provided by operating activities

$135,460

less: purchase of equipment

($59,870)

dividend

($63,850)

($123,720)

Free cash flow

$11,740

3

Martinez has Excellent liquidity

Its financial flexibility is good


Related Solutions

A comparative balance sheet for Talkington Corporation is presented below. December 31 Assets 2017 2016 Cash...
A comparative balance sheet for Talkington Corporation is presented below. December 31 Assets 2017 2016 Cash $68,000 $22,000 Accounts receivable 82,000 66,000 Inventory 170,000 189,000 Land 71,000 110,000 Equipment 280,000 200,000 Accumulated depreciation–equipment (74,000) (42,000)             Total $597,000 $545,000 Liabilities and Stockholders’ Equity Accounts payable $34,000 $47,000 Bonds payable 150,000 200,000 Common stock ($1 par) 164,000 164,000 Retained earnings 249,000 134,000             Total $597,000 $545,000 Additional information: 1. Net income for 2017 was $155,000; there were no gains or losses. 2. Cash...
A comparative balance sheet for Pearl Corporation is presented below. December 31 Assets 2017 2016 Cash...
A comparative balance sheet for Pearl Corporation is presented below. December 31 Assets 2017 2016 Cash $ 72,800 $ 22,000 Accounts receivable 83,260 67,460 Inventory 181,260 190,460 Land 72,260 111,460 Equipment 261,260 201,460 Accumulated Depreciation-Equipment (70,260 ) (43,460 )    Total $600,580 $549,380 Liabilities and Stockholders' Equity Accounts payable $ 35,260 $ 48,460 Bonds payable 150,000 200,000 Common stock ($1 par) 214,000 164,000 Retained earnings 201,320 136,920    Total $600,580 $549,380 Additional information: 1. Net income for 2017 was $127,520. No gains...
A comparative balance sheet for Crane Corporation is presented below. December 31 Assets 2020 2019 Cash...
A comparative balance sheet for Crane Corporation is presented below. December 31 Assets 2020 2019 Cash $70720 $22880 Accounts receivable 85280 68640 Inventory 176800 196560 Land 73840 114400 Equipment 291200 208000 Accumulated depreciation–equipment (76960) (43680)             Total $620880 $566800 Liabilities and Stockholders’ Equity Accounts payable $35360 $48880 Bonds payable 156000 208000 Common stock ($1 par) 170560 170560 Retained earnings 258960 139360             Total $620880 $566800 Additional information: 1. Net income for 2020 was $161200; there were no gains or losses. 2. Cash...
Newman Corporation's comparative balance sheets are presented below. Newman Corporation Comparative Balance Sheet December 31 Assets...
Newman Corporation's comparative balance sheets are presented below. Newman Corporation Comparative Balance Sheet December 31 Assets 2020 2019 Cash $15,200 $17,700 Accounts receivable 25,200 22,300 Investments (long-term) 20,000 16,000 Equipment 60,000 70,000 Accumulated depreciation (14,000) (10,000) Total Assets $106,400 $116,000 Liabilities & Stockholder Equity Accounts payable $14,600 $11,100 Bonds payable 10,000 30,000 Common stock ($1 par) 50,000 45,000 Retained earnings 31,800 29,900 Total Liabilities & Stockholder Equity $106,400 $116,000 Additional information: 1. Net income was $18,300. Dividends declared and paid...
Presented below is the comparative balance sheet for Martinez Company. Martinez Company Comparative Balance Sheet As...
Presented below is the comparative balance sheet for Martinez Company. Martinez Company Comparative Balance Sheet As of December 31, 2021 and 2020 December 31 2021 2022 Assets Cash $181,000 $272,500 Accounts receivable (net) 218,100 155,200 Short-term investments 271,100 149,100 Inventories 1,066,900 978,500 Prepaid expenses 24,800 24,800 Plant & equipment 2,604,700 1,948,400 Accumulated depreciation (1,003,600) (743,000) $3,363,000 $2,785,500 Liabilities and Stockholders’ Equity Accounts payable $49,800 $74,700 Accrued expenses 168,900 200,700 Bonds payable 452,100 189,100 Capital stock 2,108,600 1,782,200 Retained earnings 583,600...
Below is the comparative balance sheet for Swifty Corporation. Dec. 31, 2017 Dec. 31, 2016 Cash...
Below is the comparative balance sheet for Swifty Corporation. Dec. 31, 2017 Dec. 31, 2016 Cash $16,500 $20,900 Short-term investments 24,800 18,800 Accounts receivable 42,700 45,400 Allowance for doubtful accounts (1,700 ) (2,000 ) Prepaid expenses 4,200 2,400 Inventory 81,200 65,700 Land 49,700 49,700 Buildings 125,700 73,400 Accumulated depreciation—buildings (29,800 ) (22,800 ) Equipment 53,200 46,300 Accumulated depreciation—equipment (19,100 ) (15,500 ) Delivery equipment 38,800 38,800 Accumulated depreciation—delivery equipment (22,100 ) (20,700 ) Patents 15,200 –0– $379,300 $300,400 Accounts payable...
Below is the comparative balance sheet for Crane Corporation. Dec. 31, 2017 Dec. 31, 2016 Cash...
Below is the comparative balance sheet for Crane Corporation. Dec. 31, 2017 Dec. 31, 2016 Cash $16,500 $20,800 Short-term investments 25,000 18,900 Accounts receivable 43,200 44,600 Allowance for doubtful accounts (1,800 ) (1,900 ) Prepaid expenses 4,100 2,500 Inventory 81,700 65,500 Land 49,500 49,500 Buildings 125,000 73,100 Accumulated depreciation—buildings (30,000 ) (22,800 ) Equipment 52,800 46,200 Accumulated depreciation—equipment (19,100 ) (15,500 ) Delivery equipment 39,400 39,400 Accumulated depreciation—delivery equipment (22,000 ) (20,500 ) Patents 14,900 –0– $379,200 $299,800 Accounts payable...
Talbert Corp Comparative Balance Sheet December 31, 2017 December 31, 2016 Assets Cash 440,000 200,000 Short-Term...
Talbert Corp Comparative Balance Sheet December 31, 2017 December 31, 2016 Assets Cash 440,000 200,000 Short-Term Investments 600,000 ------------ Accounts Receivable (Net) 1,020,000 1,020,000 Inventory 1,380,000 1,200,000 Long-Term Investments 400,000 600,000 Plant Assets 3,400,000 2,000,0000 Accumulated Depreciation (900,000) (900,000) Patent 180,000 200,0000 Total Assets 6,520,000 4,320,000 Liabilities and Stockholder’s Equity A/P and Accrued Liabilities 1,660,000 1,440,000 Notes Payable (nontrade) 580,000 ------------ Common Stock, $10 par 1,600,000 1,440,000 Additional Paid in Capital 800,000 500,000 Retained Earnings 1,880,000 980,000 Total Liabilities and...
Wiemers Corporation’s comparative balance sheets are presented below. WIEMERS CORPORATION Balance Sheets December 31 2017 2016...
Wiemers Corporation’s comparative balance sheets are presented below. WIEMERS CORPORATION Balance Sheets December 31 2017 2016 Cash $ 4,100 $ 4,100 Accounts receivable (net) 20,900 23,200 Inventory 10,400 7,500 Land 19,900 26,000 Buildings 69,500 69,500 Accumulated depreciation—buildings (14,700 ) (10,400 )     Total $110,100 $119,900 Accounts payable $ 12,300 $ 31,600 Common stock 74,500 70,500 Retained earnings 23,300 17,800     Total $110,100 $119,900 Wiemers’s 2017 income statement included net sales of $109,000, cost of goods sold of $59,500, and net income of...
Wiemers Corporation’s comparative balance sheets are presented below. WIEMERS CORPORATION Balance Sheets December 31 2017 2016...
Wiemers Corporation’s comparative balance sheets are presented below. WIEMERS CORPORATION Balance Sheets December 31 2017 2016 Cash $ 4,200 $ 3,200 Accounts receivable (net) 21,000 23,200 Inventory 10,000 6,600 Land 19,700 26,100 Buildings 69,700 69,700 Accumulated depreciation—buildings (14,700 ) (10,300 ) Total $109,900 $118,500 Accounts payable $ 12,400 $ 31,600 Common stock 76,000 71,000 Retained earnings 21,500 15,900 Total $109,900 $118,500 Wiemers’s 2017 income statement included net sales of $111,000, cost of goods sold of $60,400, and net income of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT