Question

In: Finance

Mod 5(c) - CH 5 EXERCISES/PROBLEMS (31 pts) Hide or show questions eBook Calculator Print Item...

Mod 5(c) - CH 5 EXERCISES/PROBLEMS (31 pts)

Hide or show questions

eBook

Calculator

Print Item

Ratio of Cash to Monthly Cash Expenses

Kips Bay Medical Inc. is a medical device company that develops, produces, and sells products used in coronary surgery. The following data (in thousands) were adapted from recent financial statements.

Year 4 Year 3 Year 2 Year 1
Operations:
Net income (loss) $(5,607) $(6,060) $(5,507) $(4,250)
Net cash flows from operating activities (5,026) (5,537) (4,203) (8,105)
Balance sheet:
End of the year cash and cash equivalents 3,138 2,316 9,403 6,211
Short-term investments* 457 2,684 947 2,957
Financing activities:
Issued common stock 3,643 5,441 13,632

*Includes various short-term securities that are readily convertible to cash.

1. Compute the monthly cash expenses for Years 1 -4. Round your answers to the nearest thousand.

Monthly Cash Expenses
Year 4 $ thousand
Year 3 $ thousand
Year 2 $ thousand
Year 1 $ thousand

2. Compute the ratio of cash to monthly cash expenses for Years 1 -4. Round your answers to one decimal place.

Ratio of Cash to Monthly
Cash Expenses
Year 4          months
Year 3          months
Year 2          months
Year 1          months

3. Including short-term investments as part of cash and cash equivalents, compute the ratio of cash to monthly cash expenses for Years 1 -4. Round your answers to one decimal place.

Ratio of Cash to Monthly
Cash Expenses
Year 4          months
Year 3          months
Year 2          months
Year 1          months

4. Based on the calculations above , which of the following statements is incorrect?

Kips Bay Medical has reported losses and negative cash flows from operations in each of the four years.

Kips Bay Medical was not able to raise funds by issuing stock in Years 1 and 2.

Kips could continue to operate only 7.5 months using cash and 8.6 months using cash and short-term investments.

Long term, Kips Bay Medical must generate positive cash flows from operations in order to remain in business.

Choose the correct answer:
1

5. Based upon the preceding results in (2) and (3), an investment in Kips Bay Medical common stock would be extremely risky . Unless management of Kips could convince you that a turn around was likely and that Kips would generate positive cash flows from operations and profit in the future, you should probably not invest in Kips common stock.

Feedback

1. Keep in mind that monthly cash expense is equal to net cash flows from operations divided by 12.

2. Recall that cash and cash equivalents are divided by monthly cash expenses to arrive at the ratio of cash to monthly cash expenses.

3. Keep in mind that short term investments are added to cash and cash equivalents; then, the total is divided by monthly cash expenses to arrive at the ratio of cash to monthly cash expenses.

4. Keep in mind that short term investments are added to cash and cash equivalents; then, the total is divided by monthly cash expenses to arrive at the ratio of cash to monthly cash expenses.

5. Focus on the negative cash flows generated and losses reported by Kips Bay Medical. Unless the management of Kips convinces investors about future positive cash flows, it is risky to invest in Kips’ common stock.

2 more Check My Work uses remaining.

Solutions

Expert Solution

Year 4 Year 3 Year 2 Year 1
Operations:
Net income (loss) -5,607 -6,060 -5,507 -4,250
Net cash flows from operating activities -5,026 -5,537 -4,203 -8,105
Balance sheet:
End of the year cash and cash equivalents 3,138 2,316 9,403 6,211
Short-term investments* 457 2,684 947 2,957
Financing activities:
Issued common stock 3,643 5,441 13,632
Ans 1
Monthly Cash expense 418.8 461.4 350.3 675.4
Ans 2
Ratio of Cash to monthly expense 7.5 5.0 26.8 9.2
Ans 3
Ratio of Cash to (monthly expense + Investment) 8.6 10.8 29.6 13.6
Ans4
The following statement is incorrect "Kips Bay Medical was not able to raise funds by issuing stock in Years 1 and 2."
This is because it has issued common stocks in year 1 (13632) and Year 2 (5441) & also cash & cash equivalent has increased in year 2 despite having negative income and cashflow from operating activities, which proves that there has been cash inflow on capital account to manage the business negative cashflow

Related Solutions

Ch 7-3 Exercises & Problems Hide or show questions eBook Calculator Print Item Effect of Errors...
Ch 7-3 Exercises & Problems Hide or show questions eBook Calculator Print Item Effect of Errors in Physical Inventory Fonda Motorcycle Shop sells motorcycles, ATVs, and other related supplies and accessories. During the taking of its physical inventory on December 31, 20Y8, Fonda Motorcycle Shop incorrectly counted its inventory as $294,380 instead of the correct amount of $282,600. Enter all amounts as positive numbers. a.  State the effect of the error on the December 31, 20Y8, balance sheet of Fonda Motorcycle...
Ch 8-3 Exercises & Problems Hide or show questions eBook Calculator Print Item Internal Controls Ramona's...
Ch 8-3 Exercises & Problems Hide or show questions eBook Calculator Print Item Internal Controls Ramona's Clothing is a retail store specializing in women's clothing. The store has established a liberal return policy for the holiday season in order to encourage gift purchases. Any item purchased during November and December may be returned through January 31, with a receipt, for cash or exchange. If the customer does not have a receipt, cash will still be refunded for any item under $75. If...
Ch. 6 Prob 16A Hide or show questions eBook Calculator In the Illustrative Case in this...
Ch. 6 Prob 16A Hide or show questions eBook Calculator In the Illustrative Case in this chapter, payroll transactions for Brookins Company were analyzed, journalized, and posted for the third quarter of the fiscal year. In this problem, you are to record the payroll transactions for the last quarter of the firm's fiscal year. The last quarter begins on April 1, 20--. Narrative of Transactions: Apr. 1. Paid the treasurer of the union the amount of union dues withheld from...
W3 Assignment 2 PR.06-01B PR.06-02B PR.06-05B Hide or show questions Progress:2/3 items eBook Calculator Print Item...
W3 Assignment 2 PR.06-01B PR.06-02B PR.06-05B Hide or show questions Progress:2/3 items eBook Calculator Print Item Income Statements under Absorption Costing and Variable Costing The demand for aloe vera hand lotion, one of numerous products manufactured by Smooth Skin Care Products Inc., has dropped sharply because of recent competition from a similar product. The company's chemists are currently completing tests of various new formulas, and it is anticipated that the manufacture of a superior product can be started on December...
W1 Assignment 1 PR.01-01A PR.01-02A PR.01-05B.ALGO Hide or show questions Progress:1/3 items eBook Calculator Print Item...
W1 Assignment 1 PR.01-01A PR.01-02A PR.01-05B.ALGO Hide or show questions Progress:1/3 items eBook Calculator Print Item Classifying Costs The following is a list of costs that were incurred in the production and sale of large commercial airplanes: Classify each cost as either a product cost or a period cost. Indicate whether each product cost is a direct materials cost, a direct labor cost, or a factory overhead cost. Indicate whether each period cost is a selling expense or an administrative...
Chapter 17 HWK Hide or show questions eBook Calculator Measures of liquidity, Solvency and Profitability The...
Chapter 17 HWK Hide or show questions eBook Calculator Measures of liquidity, Solvency and Profitability The comparative financial statements of Stargel Inc. are as follows. The market price of Stargel common stock was $119.70 on December 31, 20Y2. Stargel Inc. Comparative Retained Earnings Statement For the Years Ended December 31, 20Y2 and 20Y1     20Y2     20Y1 Retained earnings, January 1 $5,375,000 $4,545,000 Net income 900,000 925,000 Total $6,275,000 $5,470,000 Dividends: Preferred stock dividends $45,000 $45,000 Common stock dividends 50,000 50,000 Total...
eBook Show Me How Calculator Print Item Determine the amount of sales (units) that would be...
eBook Show Me How Calculator Print Item Determine the amount of sales (units) that would be necessary under Break-Even Sales Under Present and Proposed Conditions Darby Company, operating at full capacity, sold 91,800 units at a price of $129 per unit during the current year. Its income statement for the current year is as follows: Sales $11,842,200 Cost of goods sold 5,848,000 Gross profit $5,994,200 Expenses: Selling expenses $2,924,000 Administrative expenses 2,924,000 Total expenses 5,848,000 Income from operations $146,200 The...
Hide or show questions Progress:1/1 items eBook Calculator Financial Statements and Closing Entries The Gorman Group...
Hide or show questions Progress:1/1 items eBook Calculator Financial Statements and Closing Entries The Gorman Group is a financial planning services firm owned and operated by Nicole Gorman. As of October 31, 2019, the end of the fiscal year, the accountant for The Gorman Group prepared an end-of-period spreadsheet, part of which follows: The Gorman Group End-of-Period Spreadsheet For the Year Ended October 31, 2019 Adjusted Trial Balance Account Title Dr. Cr. Cash $11,000 Accounts Receivable 28,150 Supplies 6,350 Prepaid...
Chapter 4 Lecture Assignment (part 1) Hide or show questions eBook Calculator Appendix: Completing an End-of-Period...
Chapter 4 Lecture Assignment (part 1) Hide or show questions eBook Calculator Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co. If a box does not require an entry, leave it blank. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2019 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 373...
Chapter 24-Problems PR.24-02.ALGO PR.24-03.ALGO Hide or show questions Progress:1/2 items eBook Show Me How Calculator Profit...
Chapter 24-Problems PR.24-02.ALGO PR.24-03.ALGO Hide or show questions Progress:1/2 items eBook Show Me How Calculator Profit Center Responsibility Reporting for a Service Company Thomas Railroad Company organizes its three divisions, the North (N), South (S), and West (W) regions, as profit centers. The chief executive officer (CEO) evaluates divisional performance using income from operations as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31: Revenues—N Region $868,700 Revenues—S...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT