ABC Inc. Assumptions PDF

# ABC Inc. ## Assumptions | Item | Unit | |---|---| | **Timing** | | | Model Start Date | Date | | Months in a period | # | | Start of Forecast Period | Date | | Number of Forecast Period | # | | **Revenue** | | | **Market Place Revenue** | | | Historical GMV | USD Million | | GMV Growth Rate...

# ABC Inc. ## Assumptions | Item | Unit | |---|---| | **Timing** | | | Model Start Date | Date | | Months in a period | # | | Start of Forecast Period | Date | | Number of Forecast Period | # | | **Revenue** | | | **Market Place Revenue** | | | Historical GMV | USD Million | | GMV Growth Rate | % | | Transactional Take Rate | % | | **Retail Revenue** | | | Transaction Volume | # of Transactions | | Transaction Volume Growth Rate | % | | Average Transaction Value | USD | | Average Transaction Value Growth Rate | % | | **Cost** | | | **Cost of Sales** | | | Cost of Goods Sold | % of Retail Revenue | | Cost as % of Retail Revenue | % | | Deliery Charges | USD | | Cost of Delivery per Package | % | | Increase in cost of Delivery per Package | % | | Payment Fees | % | | Cost as % of GMV | % | | **SG&A Expense** | | | Marketing Expense | % | | Cost as % of GMV | % | | **Staff Cost** | | | # Headcount | # | | Headcount Increase | % | | Annual Average Salary | USD | | Annual Average Salary Increase | % | | IT Cost | USD Million | | IT Cost | | Annual Increase | % | | **Other Costs** | | | Cost as % of Revenue | % | | **Working Capital** | | | Account Receivable (AR) | | | DSO | # of Days | | Inventory | | | Inventory Days | # of Days | | Accounts Payable (AP) | | | DPO | # of Days | | **Capital Expenditure (Capex)** | | | **Property Plant and Equipment (PPE)** | | | Capex as % of Revenue | % | | **Depreciation** | | | Useful Life | Years | | Salvage Value | % | | Depreciation Rate (WDV) | % | | **Debt** | | | Debt Drawdown | USD Million | | Scheduled Repayment | | | Interest Rate | % | | **Equity** | | | Equity Infusion | USD Million | | Dividend Payout Ratio | % | | **Tax** | | | Tax Rate | % | | **Valuation** | | | **Discount Rate** | | | 30-Year Government Bond Yield | % | | Beta | X | | Equity Risk Premium | % | | **Valuation Date** | | | Date of Valuation | Date | | **Terminal Value** | | Terminal Growth Rate | % | | **Current Data** | | | Current Market Price | USD | | Outstanding shares | No. in millions | ## Working | Item | Unit | |---|---| | **Timing** | | | Period Counter | # | | Period Start Date | Date | | Period End Date | Date | | Period Type | Text | | # of Days in Period | Days | | **Revenue** | | | **Market Place Revenue** | | | GMV | USD Million | | Transactional Take Rate | % | | Market Place Revenue | USD Million | | **Retail Revenue** | | | Transaction Volume | # of Transactions | | Average Transaction Value | USD | | Retail Revenue | USD Million | | Total Revenue | USD Million | | **Cost** | | | **Cost of Sales** | | | Cost of Goods Sold | USD Million | | Retail Revenue | % of Retail Revenue | | Cost as % of Retail Revenue | % | | Cost of Goods Sold | USD Million | | Deliery Charges | USD Million | | Total GMV (Marketplace GMV + Retail Revenue) | USD Million | | Average Transaction Value | USD | | # of Packages | # Million | | Average delivery cost per package | USD | | Cost of Delivery | USD Million | | Payment Fees | USD Million | | Total GMV (Marketplace + Retail) | USD Million | | Payment Cost | USD Million | | Total Cost of Sales | USD Million | | **SG&A Expense** | | | Marketing Expense | USD Million | | Total GMV | USD Million | | Total Marketing Expense | USD Million | | **Staff Cost** | | | Headcount | # | | Average Annual Salary | USD | | Total Staff Cost | USD Million | | **IT Cost** | | | Total IT Cost | USD Million | | **Other Costs** | | | Total Other Costs | USD Million | | Total SG&A Expenses | USD Million | | Total Costs | USD Million | | **Working Capital** | | | **Accounts Receivable** | | | Beginning Balance | USD Million | | Addition - Revenue | USD Million | | Reduction - Cash from Customer | USD Million | | Ending Balance | USD Million | | **Inventory** | | | Beginning Balance | USD Million | | Addition - Purhases | USD Million | | Reduction - Cost of Goods Sold | USD Million | | Ending Balance | USD Million | | **Accounts Payable** | | | Beginning Balance | USD Million | | Addition - Total Cost | USD Million | | Reduction - Cash Paid to Suppliers | USD Million | | Ending Balance | USD Million | | Total Working Capital | USD Million | | **Capital Expenditure** | | | Capital Expenditure | USD Million | | **Depreciation** | | | WDV | | Depreciation Rate (WDV) | % | | Beginning Balance | USD Million | | Addition - Capex | USD Million | | Reduction - Depreciation | USD Million | | Ending Balance | USD Million | | (consider additional capex at the beginning of the year) | | **Debt** | | | Beginning Balance | USD Million | | Adddition - Debt Drawdown | USD Million | | Reduction - Repayment | USD Million | | Ending Balance | USD Million | | Interest Expense | USD Million | | (consider additional debt at the beginning of the year) | | **Equity** | | **Paid-in Capital** | | | Beginning Balance | USD Million | | Addtion - Equity Infusion | USD Million | | Reduction - Equity Redemption | USD Million | | Ending Balance | USD Million | | **Retained Earning** | | | Beginning Balance | USD Million | | Addition (Net Profit) | USD Million | | Dividends | USD Million | | Ending Balance | USD Million | ## Financial Statements **Master Check** ### Profit & Loss Statement - Total Revenue - Cost of Sales - Gross Profit - SG&A Expenses - Earning Before Interest, Tax, Depreciation and Amortization (EBIT) - Depreciation and Amortization (D&A) - Earning Before Interest and Tax (EBIT) - Interest Expense - Profit Before Tax (PBT) - Tax Expenses - Profit After Tax (PAT) ### Balance Sheet **Asset** - **Current Assets** - Cash - Accounts Receivable - Inventory - Total Current Assets - **Non-Current Assets** - Property Plant and Equipment - Total Non-Current Assets - Total Assets **Liability and Equity** - **Current Liabilities** - Accounts Payable - Total Current Liabilities - **Non-Current Liabilities** - Debt - Total Non-Current Assets - Total Liabilities - **Shareholders' Equity** - Paid-in Capital - Retained Earning - Total Shareholders' Equity - Total Liability and Shareholders' Equity - Balance Sheet Check ### Cash Flow Statement - **Cash Flow from Operating Activities** - Net Profit (PAT) - Depreciation and Amortization - Change in Working Capital - Cash Flow from Operating Activities - **Cash Flow from Investing Activities** - Capital Expenditure - Cash Flow from Investing Activities - **Cash Flow from Financing Activities** - Debt Drawdown - Debt Repayment - Equity Infusion - Dividend - Cash Flow from Financing Activities - Beginning Cash Balance - Total Cash Generated During Period - Ending Cash Balance | Item | Period Start | Period End | Period Type | Unit | |---|---|---|---|---| | Total Revenue | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Cost of Sales | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Gross Profit | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | SG&A Expenses | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Earning Before Interest, Tax, Depreciation and Amortization (EBIT) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Depreciation and Amortization (D&A) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Earning Before Interest and Tax (EBIT) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Interest Expense | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Profit Before Tax (PBT) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Tax Expenses | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Profit After Tax (PAT) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Cash | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Accounts Receivable | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Inventory | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Total Current Assets | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Property Plant and Equipment | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Total Non-Current Assets | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Total Assets | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Accounts Payable | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Total Current Liabilities | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Debt | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Total Non-Current Assets | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Total Liabilities | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Paid-in Capital | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Retained Earning | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Total Shareholders' Equity | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Total Liability and Shareholders' Equity | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Net Profit (PAT) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Depreciation and Amortization | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Change in Working Capital | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Cash Flow from Operating Activities | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Capital Expenditure | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Cash Flow from Investing Activities | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Debt Drawdown | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Debt Repayment | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Equity Infusion | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Dividend | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Cash Flow from Financing Activities | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Beginning Cash Balance | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Total Cash Generated During Period | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Ending Cash Balance | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | ## Valuation ### Free Cash Flow to Firm (FCFF) - EBIT - Unlevered Tax - EBIT * (1 - T) - Add: Depreciation - Subtract: Increase in Working Capital - Subtract: Capital Expenditure - Free Cash Flow to Firm (FCFF) ### Free Cash Flow to Equity (FCFE) - Net Profit - Add: Depreciation - Subtract: Increase in Working Capital - Subtract: Capital Expenditure - Add: Debt Drawdown - Subtract: Debt Repayment - Free Cash Flow to Equity (FCFE) ### Discount Rate - **Cost of Debt** - Cost of incremental borrowing (Cd) - Tax Rate (t) - **Cost of Equity** - Risk Free Rate (Rf) - Beta (β) - Equity Risk Premium (Rm - Rf) - Cost of Equity (using CAPM) (Ce) - WACC - Debt Balance (D) - Equity - Debt as Proportion of Capital (D/(D+E)) - Equity as Proportion of Capital (E/(D+E)) - WACC ### Terminal Value - FCFF - Terminal Year Cash Flow - Terminal Growth Rate - Discount Rate (WACC) - Terminal Value ### FCFE - Terminal Year Cash Flow - Terminal Growth Rate - Discount Rate (WACC) - Terminal Value ### Valuations - Valuation Date - Valuation Date - **FCFF** - Date of Cash Flow - Forecasted Period Flag - FCFF - Terminal Value - Cash Flow for Valuation - # of Years from Valuation Date - Discount Rate - Discount Factor - Discounted Cash Flow - Enterprise Value (EV) - Debt - Cash - Equity Value - Outstanding shares - Intrinsic Value per share - Current Market Price - Decision - Upside/downside potential % | Item | Period Start | Period End | Period Type | Unit | |---|---|---|---|---| | EBIT | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Unlevered Tax | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | EBIT * (1 - T) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Depreciation | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Increase in Working Capital | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Capital Expenditure | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Free Cash Flow to Firm (FCFF) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Net Profit | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Depreciation | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Increase in Working Capital | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Capital Expenditure | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Debt Drawdown | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Debt Repayment | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Free Cash Flow to Equity (FCFE) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Cost of incremental borrowing (Cd) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Tax Rate (t) | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | Risk Free Rate (Rf) | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | Beta (β) | 1-Apr-21 | 31-Mar-22 | Historical | X | | | 1-Apr-22 | 31-Mar-23 | Historical | X | | Equity Risk Premium (Rm - Rf) | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | Cost of Equity (using CAPM) (Ce) | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | Debt Balance (D) | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Equity | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Debt as Proportion of Capital (D/(D+E)) | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | Equity as Proportion of Capital (E/(D+E)) | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | WACC | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | Terminal Year Cash Flow | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Terminal Growth Rate | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | Discount Rate (WACC) | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | Terminal Value | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Terminal Year Cash Flow | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Terminal Growth Rate | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | Discount Rate (WACC) | 1-Apr-21 | 31-Mar-22 | Historical | % | | | 1-Apr-22 | 31-Mar-23 | Historical | % | | Terminal Value | 1-Apr-21 | 31-Mar-22 | Historical | USD Million | | | 1-Apr-22 | 31-Mar-23 | Historical | USD Million | | Valuation Date | | | | 3/31/2024 | | Valuation Date | | | | 3/31/2022 | | Date of Cash Flow | | | | 3/31/2022 | | Forecasted Period Flag | | | | 1 | | FCFF | | | | 0 | | Terminal Value | | | | 0.0 | | # of Years from Valuation Date | | | | 0 | | Discount Rate | | | | 0.0 | | Discount Factor | | | | 0.0 | | Discounted Cash Flow | | | | 0.0 | | Enterprise Value (EV) | | | | 0 | | Debt | | | | 0 | | Cash | | | | 0 | | Equity Value | | | | 0 | | Outstanding shares | | | | 0 | | Intrinsic Value per share | | | | 0.0 | | Current Market Price | | | | 0.0 | | Decision | | | | | | Upside/downside potential % | | | | | The document contains a set of financial statements, including an income statement, balance sheet, and cash flow statement, along with a valuation analysis. The document is divided into sections, with tables and charts to show the financial data and calculations for the company. For each financial statement, the document includes both historical data and forecasts. The document also describes the assumptions, including the model start date and the number of forecast periods. Finally, the document contains a valuation analysis, which is based on the free cash flow to firm (FCFF) and free cash flow to equity (FCFE) models.