Small Business Excel Sheet Exercise You will be provided with financial data to analyze (James Confectioner’s case in your text). These assignments are int

Small Business Excel Sheet Exercise You will be provided with financial data to analyze (James Confectioner’s case in your text). These assignments are int

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Small Business Excel Sheet Exercise You will be provided with financial data to analyze (James Confectioner’s case in your text). These assignments are intended to develop your ability to work with financial data, analyze it based on the theoretical foundation you have been building, and make appropriate recommendations that will enhance the financial performance of a business or organization. Submit your work in this assignment drop box.

i have provided a excel sheet underneath so use the same sheet and under the subject line please use the formulas to add the numbers in it.

you can use the same excel sheet to answer the question..

do not send me answer in word sheet as the answer must be typed in excel sheet attached in the question. Sheet1

JAMES CONFECTIONERS

Financial Statements

INCOME STATEMENTS 20XX RATIO ANALYSIS

20XX SUBJECT INDUSTRY MEDIAN

Sales Current 1.7

COGS Quick 0.8

GP A/R Turn 15.7

SGA Exp. Avg Coll 23

Deprec. Inv Turn 4.9

EBIT (Oper. Income)

Interest OI ROI

EBT OPM

Income Taxes FA Turn 8.2

Net Income

Debt/TA 0.7

Times Int 2.3

BALANCE SHEETS

20XX ROE 16.5

ASSETS ROA 5.6

CURRENT ASSETS

Cash

Accounts Receivable

Inventories

Other Current

TOTAL CURRENT ASSETS

FIXED ASSETS

Gross PP&E

Accumulated Depreciation

Net PP&E

Other Fixed

TOTAL ASSETS

LIABILITIES & EQUITY

CURRENT LIABILITIES

Accounts Payable/Accruals

Short Term Debt

TOTAL CURRENT LIABILITIES

LONG TERM DEBT

STKHLDRS EQUITY

Common Stock (par+paid-in)

Retained Earnings

TOTAL LIABILITIES & EQUITY

Sheet2

Sheet3

Looking for this or a Similar Assignment? Click below to Place your Order