#### Question Details

##### [solution] » BUSN460 Individual Financial Analysis Project Student Name:

Brief item decscription

Step-by-step solution file

Item details:

BUSN460 Individual Financial Analysis Project Student Name:
More:

Can anyone help me complete this project?  See attached

BUSN460 Individual Financial Analysis Project

Student Name: Rebecca Dugan Instructions:

Go to the CanGo intranet found in the Report Guide tab under Course Home

Use the financial statements from the most recent year to fill in the table below.

You may find some formulae calling for an average, e.g., average inventory, average receivables.

Because we only have the Balance sheet for one year, you can only use the one year number not an average.

Assume interest expense is \$0.00

Be careful of the Debt equity ratio. The review covers debt asset ratio as an example of how to calculate ratios and that is different from debt equity

and that is different from the debt equity ratio so think about how you calculate the debt equity ratio using the debt asset ratio as an example.

Be sure to cite your references Green boxes to be filled in by instructor

Ratio Example: Efficiency Ratio:

Receivables

Turnover

Efficiency Ratio:

Inventory

Turnover

(express the

ratio in words) Detailed

calculation

(actual

numbers from

financial

statements

used for the

calculation) Term A/Term B

(Term A divided

by Term B) 1000/2000 Net Credit

Sales/Average

Accounts

Receivable Costs of Goods

Sold/Average

Inventory Financial

Total

Leverage Ratio:

Liabilities/Total

Debt/Equity Ratio Equity 50000000/32120

000 9000000/320000

00 94900000/23590

0000 Final number Explanation of why ratio Earned points

(final result of

is important

(up to 3 points

the detailed

per &quot;box&quot;/cell)

calculation) .50 The

ratio

measures

how of

This

is the

explanation

many

times

a

can

the role of this ratio and

turn why

its accounts

receivable

it is important

into cash. Retrieved

from:http://www.myaccoun

tingcourse.com/financialThis

measures how much

ratios/accounts-receivableaverage

inventory is sold

1.56 turnover-ratio

during a period. Retrieved

from:

http://www.myaccountingc

ourse.com/financialratios/inventory-turnover0.28 ratio

This compares a company's

total debt to total equity.

http://www.myaccountingc

ourse.com/financial0.4 ratios/debt-to-equity-ratio 3 0.0 0.0 Grade for above Liquidity Ratio:

Current Ratio

Quick Ratio

Assets/Current

202020000/3750

Cash

and Cash

Liabilities

0000

equivalents+shor

tterm

investment+curr

ent

recievables/currre 170020000/3750

nt liabilities

0000 Current

Liquidity: Working Assets/Current

Capital

Liabilities

0000 Net

Profitability Ratio: Income/Average

Return on Assets Total assets

000 Profitability Ratio: Net Income/Net

Return on Sales

Sales

Points 5486000/500000

00 This measures a company's

ability to pay off its shortterm liabilities with its

current assests. Retrived

from:

http://www.myaccountingc

ourse.com/financialmeasures the

5.39 This

ratios/current-ratio

company's ability to pay its

current liabilities with quick

http://www.myaccountingc

This

measures a company's

ourse.com/financialability

to pay off its short4.53 ratios/quick-ratio

term liabilities with its

current assests. Retrived

from:

This

mesuares the net

http://www.myaccountingc

income

produced by total

ourse.com/financialassests

during a period by

5.39 ratios/current-ratio

comparing net income to

the average total assests.

This

measures

Retrived

from: a company?s

performance

by analyzing

http://www.myaccountingc

what

percentage

of total

ourse.com/financialcompany

revenues

0.02 ratios/current-ratio are

actually converted into

company profits. Retrieved

from:

http://www.myaccountingc

ourse.com/financial0.11 ratios/return-on-sales 0.0 0.0 0.0 0.0 0.0 0.0 0.0 and that is different from debt equity ratio,

debt asset ratio as an example. Instructor feedback

STATUS
QUALITY
Approved

This question was answered on: Feb 21, 2020

Solution~00065933964.zip (18.37 KB)