Cover
Model information | ㅤ |
Company name | ㅤ |
Latest BS date (year0) | ㅤ |
Currency | ㅤ |
Units | (million/ thousand) |
Analyst name | ㅤ |
Circular switch | ㅤ |
Assumptions
projects upcoming changes on key terms in financial statements based on historical years figures.
search ideas from: Broker research, Bloomberg etc, consensus.
Assumptions | History Year | Project Year |
Income statement | ㅤ | ㅤ |
Sales growth | ㅤ | ㅤ |
COGS as % of sales | ㅤ | ㅤ |
SG&A as % of sales | ㅤ | ㅤ |
Tax rate as % of sales | ㅤ | ㅤ |
Shareholder info | ㅤ | ㅤ |
dividend payout as % of net income | ㅤ | ㅤ |
Weight average common shares outstanding | ㅤ | ㅤ |
PP&E | ㅤ | ㅤ |
Working capital | ㅤ | ㅤ |
Debt | ㅤ | ㅤ |
Other assumptions | ㅤ | ㅤ |
Calculates
Calculates | Hist.Year | Proj.Year |
PP&E | ㅤ | ㅤ |
Net PP&E beginning balance | ㅤ | ㅤ |
Capital expenditure | ㅤ | ㅤ |
Annual depreciation | ㅤ | ㅤ |
Net PP&E ending balance | ㅤ | ㅤ |
Retained earnings | ㅤ | ㅤ |
Beginning balance | ㅤ | ㅤ |
Net income | ㅤ | ㅤ |
Dividends paid | ㅤ | ㅤ |
Ending balance | ㅤ | ㅤ |
Operational Working capital | ㅤ | ㅤ |
Account receivable | ㅤ | ㅤ |
Inventories | ㅤ | ㅤ |
Current assets except cash | ㅤ | ㅤ |
Account payable | ㅤ | ㅤ |
Operating working capital | ㅤ | ㅤ |