Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A . Use year - end data to calculate the current ratio, the quick ratio, and the net working capital ( NWC ) to total

A. Use year-end data to calculate the current ratio, the quick ratio, and the net working capital (NWC) to total assets ratio for 2015 and 2016 for the Castillo Company. Explain what these changes might suggest.
B. Use Castillos complete income statement data and the changes in balance sheet items between 2015 and 2016 to determine the firms cash build and cash burn for 2016. Did Castillo have a net cash build or net cash burn for 2016?
C. Convert the annual cash build and cash burn amounts calculated in Part B to monthly cash build and cash burn rates. Also indicate the amount of the net monthly cash build or cash burn rate. The Castillo Products Company was started in 2014. The company manufactures components for personal decision assistant (PDA) products and for other hand-held electronic products. A difficult operating year 2015 was followed by a profitable 2016. However, the founders (Cindy and Rob Castillo) are still concerned about the venture's liquidity position and the amount of cash being used to operate the firm. Following are income statements and balance sheets for the Castillo Products Company for 2015 and 2016.
CASTILLO PRODUCTS COMPANY
\table[[Income Statement,2015_,2016_],[Net Sales,$900,000,$1,500,000],[Cost of Goods Sold,540,000_,900,000_],[, Gross Profit,360,000,600,000],[Marketing,90,000,150,000],[General & Administrative _,250,000,250,000],[Depreciation,40,000_,40,000_],[, EBIT,-20,000,160,000],[Interest,45,000,60,000_],[, Earnings Before Taxes,-65,000,100,000],[Income Taxes,0_,25,000_],[, Net Income (Loss),-$\bar ($65,000),$75,000]]
\table[[Balance Sheet,2015,2016],[\bar ( Cash ),$55,000,$20,000],[Accounts Receivables,200,000,280,000],[Inventories,400,000_,500,000_],[Total Current Assets,655,000,800,000],[Gross Fixed Assets,450,000,540,000],[Accumulated Depreciatior,-100,000_,-140,000_],[Net Fixed Assets,350,000,400,000],[Total Assets,$1,005,000,$1,200,000],[Accounts Payable,$135,000,$160,000],[Accruals,50,000,70,000],[Bank Loan,90,000,100,000],[Total Current Liabilities,275,000,330,000],[Long-Term Debt,300,000,400,000],[Common Stock ( $.05par),150,000,150,000],[Additional Paid-in-Capital,200,000,200,000],[Retained Earnings,80,000,120,000_],[Total Liab & Equity,$1,005,000,$1,200,000]]
A. Use year-end data to calculate the current ratio, the quick ratio, and the net working capital (NWC) to total assets ratio for 2015 and 2016 for the Castillo Company. Explain what these changes might suggest.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Technical Analysis Of The Financial Markets

Authors: John J. Murphy

1st Edition

0735200661, 978-0735200661

More Books

Students also viewed these Finance questions

Question

Define failure. (p. 273)

Answered: 1 week ago

Question

Explain the causes of indiscipline.

Answered: 1 week ago