VLookup Depreciation

VLookup Depreciation - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Accelerated Depreciation Model Using VLookUp Tables, (Bennninga pp 84+) Sales growth 10% Current assets/Sales 15% Current liabilities/Sales 8% Net fixed assets/Sales 77% Costs of goods sold/Sales 50% Depreciation rate 10% Interest rate on debt 10.00% 8.00% Tax rate 40% Dividend payout ratio 40% Year 0 1 2 3 4 5 Income statement Sales 1,000 1,100 1,210 1,331 1,464 1,611 Costs of goods sold (500) (550) (605) (666) (732) (805) Interest payments on debt (32) (32) (32) (32) (32) (32) 6 Err:522 Err:522 Err:522 Err:522 Err:522 Depreciation (100) Profit before tax 374 Err:522 Err:522 Err:522 Err:522 Err:522 Taxes (150) Err:522 Err:522 Err:522 Err:522 Err:522 Profit after tax 225 Err:522 Err:522 Err:522 Err:522 Err:522 Dividends (90) Err:522 Err:522 Err:522 Err:522 Err:522 Retained earnings 135 Err:522 Err:522 Err:522 Err:522 Err:522 Balance sheet Cash and marketable securities 80 Err:522 Err:522 Err:522
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

VLookup Depreciation - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online