Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You need to look into Insights Inc. cash flows and compute selected financial ratios using the financial statements provided IN PICTURE BELOW. Required: (a) Calculate

You need to look into Insights Inc. cash flows and compute selected financial ratios using the financial statements provided IN PICTURE BELOW.

Required: (a) Calculate the following for 2020:

i. Operating Cash Flow

ii. Net Capital Spending

iii. Change in Net Working Capital

iv. Cash Flow from Assets

v. Cash Flow to Creditors

vi. Cash Flow to Stockholders

(b) A companys asset utilization or turnover ratios are intended to display how efficiently or intensively a firm uses its assets to generate sales. Calculate the following turnover ratios for 2020:

i. Inventory Turnover

ii. Days sales in inventory

iii. NWC Turnover

iv. Total Asset Turnover

c) The Finance Manager is trying to ensure that the companys excess cash holdings are all invested in interest-bearing short-term instruments. Carriums bankers have provided details on enhanced savings accounts that is offered to business clients:

Option 1: Annual interest rate of 8%, compounded weekly;

Option 2: Annual interest rate of 8.25%, compounded monthly;

Option 3: Annual interest rate of 8.30%.

Required: Advise the Finance Manager on the best option.

image text in transcribed

The following comprehensive assessment is based on a continuing case study of Carrium Insights Inc. The following financial statements have been provided: Carrium Insights Inc. Income Statement For the year ended December 31, 2020 Sales Cost of Goods Sold Selling & Marketing Costs Admin. Expenses Depreciation Expense Earnings before Interest & Taxes Interest Expense Taxable income Taxation (20%) Net Income 2020 ('000s) 2,800 (1,400) (75) (25) (50) 1,250 (20 1,230 (246) 984 Dividends (50%) Addition to Retained Earnings 492 492 Carrium Insights Inc. Statement of Financial Position As at December 31, 2019 & 2020 2019 ('000s) 2020 ('000) 2019 ('000s) 2020 ('000) ASSETS Current Assets Inventories Accounts Receivables Cash & Equivalents LIABILITIES & EQUITY Current Liabilities Accounts Payables Notes Payables 600 300 1.100 2,000 680 340 1,340 2,360 1,100 700 1,800 1,360 860 2,220 Non-current Liabilites 770 568 Non Current Assets, Net 1,870 2,240 Total Liabilities 2,570 2,788 Equity Common Stock Retained Earnings Total Equity 820 480 1,300 840 972 1,812 TOTAL ASSETS 3,870 4,600 TOTAL LIAB. & EQUITY 3,870 4,600

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions

Question

Solve the equation and check. 4-25 = -

Answered: 1 week ago