Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

From above information A company has the following ratios: Current ratio - .85 Inventory to Sales Conversion Period 180 days Sales to Cash Conversion Period

image text in transcribed

From above information

A company has the following ratios:

Current ratio - .85 Inventory to Sales Conversion Period 180 days Sales to Cash Conversion Period 65 days Purchases to Payments Conversion Period - 7 days The accountant also reports that the gross profit margin is 15% and the next profit margin is 3%.

Now you are being provided with this additional information on the company.

The company also has a bank line of credit that allows the company to borrow any shortfall it might have in cash. Interest on the loan is 10%. Assume the loan remained constant throughout the year. The company likes to keep no less than $25,000 in its bank account. Assume that outstanding accounts payable are all related to inventory purchases.

The company has $1,200,000 of equity and $140,000 in retained earnings at the end of the year.

Sales in the most recent year were $2,600,000.

Ignore income tax for purposes of this problem.

Build a balance sheet and income statement financial model.

What is the company's return on investment?

$ 2,768 (1,210) 1,558 $ ABC Enterprises Income Statement For the year ended 20xx Net sales Cost of goods sold Gross profit Operating expenses Depreciation Other operating expenses Total expenses Earnings before interest and taxes Interest expense Net profit before tax Taxes Net income 160 200 (360) 1,198 (160) 1,038 (312) 726 $ ABC Enterprises Balance Sheet As of 20xx Assets 240 850 Cash Accounts receivable Inventory Net fixed assets 845 3,410 Total assets $ 5,345 710 Liabilities and Equity Accounts payable Short-term notes payable Long term liabilities Total liabilities 770 1,100 2,580 Common Stock Retained earnings Total shareholder's equity 1,160 1,605 2,765 Total liabilities and equity $ 5,345

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

Lords Of Finance The Bankers Who Broke The World

Authors: Liaquat Ahamed

1st Edition

0143116800, 978-0143116806

More Books

Students also viewed these Finance questions

Question

3-18. An advertisement for peanut butter?

Answered: 1 week ago