Financial Calcs Formulas Flashcards
Capital Cost Allowance (CCA)
CCA = UCC * CCA Rate * 50% (in the first year)
Depreciation Expense
Depreciation Expense = (Cost - Salvage Value) / Useful Life
Cost of Goods Sold (COGS)
COGS = Beginning Inventory + Purchases - Ending Inventory
Net Income
Net Income = Revenue - Expenses
Shareholders’ Equity
Shareholders’ Equity = Total Assets - Total Liabilities
Gross Rent Multiplier (GRM)
GRM = Property Price / Gross Rental Income
Return on Investment (ROI)
ROI = (Net Profit / Cost of Investment) * 100
Debt Service Coverage Ratio (DSCR)
DSCR = Net Operating Income / Total Debt Service
Operating Expense Ratio (OER)
OER = Operating Expenses / Gross Operating Income
Cash on Cash Return
Annual Pre - Tax Cash Flow / Total Cash Invested
Amortization
Amortization Schedule Calculation
Annual Percentage Rate (APR)
APR = [(Fees + Interest) / Principal] / n * 365
Value of Cash
Cash = Total Current Assets - Merchandise Inventory - Accounts Receivable
Value of Machinery
Machinery = Total Non - Current Assets + Accumulated Depreciation - Land
Total Non-Current Assets
Total Non - Current Assets = Total Assets - Total Current Assets
Share Capital
Share Capital = Total Shareholders’ Equity - Retained Earnings
Total Shareholders’ Equity
Total Shareholders’ Equity = Total Liabilities and Shareholders’ Equity - Total Liabilities
Total Liabilities and Shareholders’ Equity
Total Liabilities and Shareholders’ Equity = Total Assets
Income Tax Expense
Income Tax Expense = Revenue - (Interest Payments + Operating Expenses + Cost of Goods Sold) - After Tax Net Income
Building’s Capital Cost Allowance (First Year)
CCA = (CCA Rate * ((Annual Depreciation Expense * Estimated Economic Life) + Salvage Value)) * 0.5
UCC (Undepreciated Capital Cost)
UCC = Cost of Property - Cumulative CCA Claimed
Revenue
Revenue = Price * Quantity Sold
Operating Expenses
Operating Expenses = Salaries + Rent + Utilities + Office Supplies + Depreciation + Miscellaneous Expenses