Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Alitalia manufacturing company was organized five year ago and manufactures toys. Its most recent three years balance sheets and income statements are reproduced below: Alitalia

Alitalia manufacturing company was organized five year ago and manufactures toys. Its most recent three years balance sheets and income statements are reproduced below:

Alitalia Manufacturing Company

Balance Sheet Statement

June 30, 2020, Year 2019 and Year 2018

Particulars

2020

2019

2018

Assets

Cash

$12,000

$15,000

$16,000

Accounts receivable, net

1,83,000

80,000

60,000

Inventory

1,42,000

97,000

52,000

Other current assets

5,000

6,000

4,000

Plant and equipment, net

1,60,000

1,10,000

70,000

Total assets

$5,02,000

$3,08,000

$2,02,000

Liabilities and Equity

Accounts Payable

$1,47,800

$50,400

$22,000

Income tax payable

30,000

14,400

28,000

Long term liabilities

1,20,000

73,000

22,400

Common stock, $5 par value

1,10,000

1,10,000

80,000

Retained earnings

94,200

60,200

49,600

Total liabilities and equity

$5,02,000

$3,08,000

$2,02,000

Alitalia Manufacturing Company

Condensed Income Statement

June 30, 2020, Year 2019 and Year 2018

Particulars

2020

2019

2018

Sales

$16,50,000

$12,50,000

$10,50,000

Cost of goods sold

(9,27,000)

(8,10,000)

(5,12,000)

Gross profit

7,57,000

4,40,000

5,38,000

Marketing and administrative expenses

(6,70,000)

(3,96,700)

(4,67,400)

Operating income

87,000

43,300

70,240

Interest costs

(12,000)

(7,300)

(2,240)

Income before taxes

75,000

36,000

68,000

Income taxes

(30,000)

(14,400)

(28,000)

Net income

$45,000

$21,600

$40,000)

A reconciliation of retained earnings for years ended June 30, Year 4, and Year 5, follows:

Alitalia Manufacturing Company

Condensed Income Statement

June 30, 2020, Year 2019 and Year 2018

Particulars

2020

2019

Balance, Beginning

$60,200

$49,600

Add: Net income

45,000

21,600

Subtotal

1,05,200

71,200

Deduct: Dividend paid

(11,000)

(11,000)

Balance, ending

$94,200

$60,200

Additional Information:

  • All sales are on account.

  • Long term liabilities are owed to companys bank.

  • Terms of sales are net 30 days.

Required:

  • Compute the following measures for both Years 2019 and 2020:

  • Working capital

  • Current ratio

  • Acid test ratio

  • Accounts receivable turnover ratio

  • Collection period of receivables

  • Inventory turnover

  • Days to sell inventory

  • Debt-to-equity ratio

  • Time interest earned

  • Using Year 2019 as the base year, compute an index-number trend series for:

  • Sales

  • Cost of goods sold

  • Gross profit

  • Marketing and administrative costs

  • Net income

  • Based on your analysis in (a) and (b), prepare a one page report yielding a recommendation on whether to grant a loan to Ian Manufacturing Company support your recommendation with relevant analysis.

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

More Books

Students also viewed these Accounting questions