Formulas .xlsx - Straight Line*E Depreciable Base Salvage Value Useful Life 300,000.00 10,000.00 8.00 Depreciation \$36,250.00 Double Declining Balance

# Formulas .xlsx - Straight Line*E Depreciable Base Salvage...

• 39
• 100% (3) 3 out of 3 people found this document helpful

This preview shows page 1 - 12 out of 39 pages.

Straight Line Depreciable Base: 300,000.00 Salvage Value: 10,000.00 Useful Life: 8.00 Depreciation: \$36,250.00 Double Declining Balance Depreciable Base: 473,000.00 Salvage Value: 42,000.00 Useful Life: 5.00 Period in question: 4.00 Depreciation: \$40,867.20 Answer if year 1 needed: \$20,433.60 Sum of Years Digits Depreciable Base: 700,000.00 Salvage Value: 50,000.00 Useful Life: 8.00 Period in question: 5.00 Depreciation: \$72,222.22 Depletion Cost
*Example question: What is the depreciation of this Straight Line Depreciation w/ changed life & salvage New Depreciable Base 155,000.00 New Salvage Value 20,000.00 New Useful Life 6.00 *After doin # of periods since initial valuation 4.00 this one Depreciation already accumulated 145,000.00 & # of peri New Depreciation expense: 22,500.00
s asset in year 4?
Patent Amortization Patent Amt 36,000.00 Finite Life 10.00 Amortization per year: 3,600.00
Current Ratio= Quick Ratio (Acid Test)= Cash Ratio= Operating Cash Flow Ratio= Debt to Equity Ratio= Debt to Total Assets Ratio= Gross Profit Percentage= Return on Assets= Return on Equity= Inventory Turnover Ratio= Times Interest Earned (Accrual Basis)= Times Interest Earned (Cash Basis)= Long-term Debt to Equity Ratio= Long-term Debt to Total Assets Ratio= Operating Margin Percentage= Net Profit Margin Percentage= Accounts Receivable Turnover Ratio=
Asset Turnover Ratio= Return on Common Equity= Dividend Yield Ratio= Dividend Payout Ratio= Total Payout Ratio= Earnings Per Share (EPS) Ratio= Stock Repurchase Payout Ratio=
Short-Term Liquidity Ratios Current Assets/ Current Liabilities (Cash+Short term investments + Receivables)/ Current Liabilities