Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use Castillo Products Company's complete income statement data and the changes in balance sheet items between 2018 and 2019 to determine the firm's cash build

Use Castillo Products Company's complete income statement data and the changes in balance sheet items between 2018 and 2019 to determine the firm's cash build and cash burn for 2019. Did the firm have net cash burn or net cash build for 2019? Enter the amount in the box below. (Sample Answer Format: $100,000 cash build. For cash burn, do not enter a negative sign. Just enter the dollar amount with dollar sign and comma, space, cash burn).

Convert the annual cash build and cash burn amounts calculated in the question to monthly cash build and cash burn rates. Enter the amount of the net monthly cash build or cash burn rate in the box below (sample response format: $9,500.00 cash burn).

The Castillo Products Company was started in 2017. The company manufactures components for personal decision assistant (PDA) products and for other hand-held electronic products. A difficult operating year 2018 was followed by a profitable 2019. However, the founders (Cindy and Rob Castillo) are still concerned about the ventures 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 2018 and 2019. (format your response like this: $120,000.00 cash burn)

CASTILLO PRODUCTS COMPANY

Income Statement 2018 2019

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) -$65,000 $75,000

Balance Sheet 2018 2019

Cash $50,000 $20,000

Accounts Receivables 200,000 280,000

Inventories 400,000 500,000

Total Current Assets 650,000 800,000

Gross Fixed Assets 450,000 540,000

Accum. Depreciation -100,000 -140,000

Net Fixed Assets 350,000 400,000

Total Assets $1,000,000 $1,200,000

Accounts Payable $130,000 $160,000

Accruals 50,000 70,000

Bank Loan 90,000 100,000

Total Current Liabilities 270,000 330,000

Long-Term Debt 300,000 400,000

Common Stock ($.05 par) 150,000 150,000

Additional Paid-in-Capital 200,000 200,000

Retained Earnings 80,000 120,000

Total Liab. & Equity $1,000,000 $1,200,000

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

The 30 Minute Stock Trader

Authors: Laurens Bensdorp

1st Edition

1619615738, 978-1619615731

More Books

Students also viewed these Finance questions