Assign1Sol - FULL NAME STUDENT NUMBER DGD NU ER DGD NUMBER...

This preview shows pages 1–4. Sign up to view the full content.

FULL NAME, STUDENT NUMBER, D

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
DGD NUMBER
FINANCIAL ANALYSIS MODEL ANALYST'S NAME Dr. Glenn L. Stevens NAME OF COMPANY Sample Firm 1996 NUMBER OF YEARS OF DATA 3 INCOME STATEMENT 1996 1997 1998 Sales Revenue \$1,500 \$1,550 \$1,700 \$0 \$0 Less: Cost of Goods Sold \$1,000 \$1,030 \$1,040 \$0 \$0 Gross Profits \$500 \$520 \$660 =IF(\$B\$8>4,F13-F14," ") Less: Operating Expenses: Selling Expense \$140 \$150 \$155 \$0 \$0 General / Admin. Exp. \$260 \$270 \$275 \$0 \$0 Lease Expense \$5 \$0 \$2 \$0 \$0 Depreciation Expense \$10 \$11 \$12 \$0 \$0 Total Operating Expenses \$415 \$431 \$444 =IF(\$B\$8>4,SUM(F17:F20)," ") Operating Profits \$85 \$89 \$216 =IF(\$B\$8>4,F15-F21," ") Less: Interest Expense \$23 \$29 \$30 \$0 \$0 Net Profits Before Taxes \$62 \$60 \$186 =IF(\$B\$8>4,F22-F23," ") Less: Taxes \$10 \$12 \$15 \$0 \$0 Net Profit After Taxes \$52 \$48 \$171 =IF(\$B\$8>4,F24-F25," ") Less: Pref. Stock Divds. \$1 \$0 \$0 \$0 \$0 \$51 \$48 \$171 IF(\$B\$8>4,F26-F27," ") BALANCE SHEET Current Assets: Cash \$31 \$12 \$18 \$0 \$0 Marketable Securities \$82 \$66 \$68 \$0 \$0 Accounts Receivable \$104 \$152 \$160 \$0 \$0 Inventories \$145 \$191 \$200 \$0 \$0 Total Current Assets \$362 \$421 \$446 =IF(\$B\$8>4,SUM(F33:F36)," ") Gross Fixed Assets (at cost): \$180 \$195 \$200 \$0 \$0 Machinery and Equipment \$0 \$0 \$0 \$0 \$0 \$0 \$0 \$0 \$0 \$0 Vehicles \$0 \$0 \$0 \$0 \$0 Other (Inc. Fin. Leases) \$0 \$0 \$0 \$0 \$0 Total Gross Fixed Assets \$180 \$195 \$200 =IF(\$B\$8>4,SUM(F39:F43)," ") Less: Accumulated Depreciation \$52 \$63 \$65 \$0 \$0 Net Fixed Assets \$128 \$132 \$135 =IF(\$B\$8>4,F44-F45," ") Other Assets \$0 \$0 \$0 \$0 \$0 Total Assets \$490 \$553 \$581 =IF(\$B\$8>4,F37+F46," ") Current Liabilities: 1996 1997 1998 =IF(\$B\$8>4,\$E\$12+1," ") Accounts Payable \$126 \$136 \$150 \$0 \$0 Notes Payable \$190 \$200 \$140 \$0 \$0 Accruals \$25 \$27 \$28 \$0 \$0 Taxes Payable \$0 \$0 \$0 \$0 \$0 Other Current Liabilities \$0 \$0 \$0 \$0 \$0 Total Current Liabilities \$341 \$363 \$318 =IF(\$B\$8>4,SUM(F51:F55)," ") L / T Debt (Inc. Financial Leases) \$40 \$38 \$13 \$0 \$0 Total Liabilities \$381 \$401 \$331 =IF(\$B\$8>4,F56+F57," ") Preferred Stock \$0 \$0 \$0 \$0 \$0 Common Stock \$20 \$20 \$20 \$0 \$0 Paid-In Capital In Excess of Par \$30 \$30 \$30 \$0 \$0 Retained Earnings \$59 \$102 \$200 \$0 \$0 Total Stockholders' Equity \$109 \$152 \$250 =IF(\$B\$8>4,SUM(F59:F62)," ") \$490 \$553 \$581 =IF(\$B\$8>4,F58+F63," ") \$0 \$0 \$0 =IF(\$B\$8>4,F64-F48," ")

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/01/2010 for the course COMPUTER S CSI1306 taught by Professor Aziri during the Spring '10 term at University of Ottawa.

Page1 / 6

Assign1Sol - FULL NAME STUDENT NUMBER DGD NU ER DGD NUMBER...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online