0% found this document useful (0 votes)
51 views42 pages

My Templates - 2

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
51 views42 pages

My Templates - 2

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 42

Income Statement - USD Millions

Particulars 2024 2025 2026 2027 2028


Revenue from Operations $ 950.00 $ 1,064.00 $ 1,191.68 $ 1,334.68 $ 2,162.18

Total Revenue $ 950.00 $ 1,064.00 $ 1,191.68 $ 1,334.68 $ 2,162.18


Advertising & Promotion $ 245.00 $ 281.32 $ 267.25 $ 269.93 $ 275.33
Depreciation and Amortization $ 38.46 $ 38.69 $ 38.92 $ 39.16 $ 39.39
Maintenance $ 19.25 $ 19.27 $ 19.28 $ 19.30 $ 19.31
Rent $ 15.15 $ 15.23 $ 15.30 $ 15.38 $ 15.46
Salaries, Benefits & Wages $ 560.28 $ 588.29 $ 617.71 $ 648.59 $ 681.02
Logistics $ 64.00 $ 64.01 $ 64.03 $ 64.04 $ 64.05
Production $ 45.22 $ 45.45 $ 45.67 $ 45.90 $ 46.13
Utilities $ 13.36 $ 13.37 $ 13.38 $ 13.40 $ 13.41
Other Expense
Total Expenses $ 1,000.72 $ 1,065.63 $ 1,081.55 $ 1,115.69 $ 1,154.10
EBIT $ -50.72 $ -1.63 $ 110.13 $ 218.99 $ 1,008.09
Interest Expenses $ 4.75 $ 5.32 $ 5.96 $ 6.67 $ 10.81
EBT $ -55.47 $ -6.95 $ 104.17 $ 212.32 $ 997.28
Tax $ 26.04 $ 53.08 $ 249.32
Net Profit/Loss $ -55.47 $ -6.95 $ 78.13 $ 159.24 $ 747.96
Profitability Ratio -6% -1% 7% 12% 35%
=> Projected

Net Profit/Loss
$800.00

$700.00

$600.00

$500.00

$400.00

$300.00

$200.00

$100.00

$-
1 2 3 4 5
$-100.00
Sources of Funds
Sl. No Source Amount Description
1 Jv with VINATABA $ 450.00
2 Convertible Bonds $ 580.00
Sources of Fun
3 Bank Debt $ 370.00

Total $ 1,400.00

Jv with VINATABA Convertible B


Sources of Funds

ith VINATABA Convertible Bonds Bank Debt


Allocation of Funds
Sl. No Particulars Amount Description
1 Marketing $ 245.00
2 PR $ 162.00
3 Legal Costs $ 438.50
4 S&D $ 64.00 Allocation of Funds
5 Diversification Costs $ 480.00
Coningent Funds $ 10.50
Total $ 1,400.00

Marketing PR Legal Costs


S&D Diversification Costs Coningent Funds
of Funds

Legal Costs
Costs Coningent Funds
Balance Sheet - INR Cr
ASSETS 2024 2025 2026 2027 2028 => Projected
CURRENT ASSETS
Cash ₹ 200.00 ₹ 230.00 ₹ 264.50 ₹ 304.17 ₹ 349.80
Accounts Receivable ₹ 208.00 ₹ 208.42 ₹ 208.83 ₹ 209.25 ₹ 209.67
Inventory ₹ 856.00 ₹ 915.92 ₹ 980.03 ₹ 1,048.64 ₹ 1,122.04
Prepaid Expenses ₹ 646.00 ₹ 646.03 ₹ 646.06 ₹ 646.10 ₹ 646.13
Short-Term Investments ₹ 456.00 ₹ 478.80 ₹ 502.74 ₹ 527.88 ₹ 554.27
TOTAL CURRENT ASSETS ₹ 2,366.00 ₹ 2,479.17 ₹ 2,602.17 ₹ 2,736.04 ₹ 2,881.91
FIXED (LONG-TERM) ASSETS
Long-Term Investments ₹ 200.00 ₹ 236.00 ₹ 278.48 ₹ 328.61 ₹ 387.76
Property, Plant, and Equipment ₹ 34.00 ₹ 56.00 ₹ 78.00 ₹ 90.00 ₹ 120.00
(Less Accumulated Depreciation) ₹ 45.00 ₹ 45.00 ₹ 45.00 ₹ 78.00 ₹ 12.00
Intangible Assets ₹ 54.00 ₹ 54.27 ₹ 54.54 ₹ 54.81 ₹ 55.09
TOTAL FIXED (LONG-TERM) ASSETS ₹ 333.00 ₹ 391.27 ₹ 456.02 ₹ 551.42 ₹ 574.84
OTHER ASSETS
Deferred Income Tax ₹ 300.00 ₹ 310.00 ₹ 320.00 ₹ 330.00 ₹ 340.00
Other ₹ 100.00 ₹ 120.00 ₹ 140.00 ₹ 160.00 ₹ 170.00
TOTAL OTHER ASSETS ₹ 400.00 ₹ 430.00 ₹ 460.00 ₹ 490.00 ₹ 510.00

TOTAL ASSETS ₹ 3,099.00 ₹ 3,300.44 ₹ 3,518.19 ₹ 3,777.46 ₹ 3,966.76

LIABILITIES AND SHAREHOLDER'S EQUITY 2024 2025 2026 2027 2028


CURRENT LIABILITIES
Accounts Payable ₹ 45.00 ₹ 56.00 ₹ 54.00 ₹ 67.00 ₹ 78.00
Short-Term Loans ₹ 30.00 ₹ 35.00 ₹ 40.00 ₹ 45.00 ₹ 50.00
O/S Salaries and Wages ₹ 10.00 ₹ 20.00 ₹ 30.00 ₹ 40.00 ₹ 40.00
TOTAL CURRENT LIABILITIES ₹ 85.00 ₹ 111.00 ₹ 124.00 ₹ 152.00 ₹ 168.00
LONG-TERM LIABILITIES
Long-term debt ₹ 23.00 ₹ 34.00 ₹ 45.00 ₹ 56.00 ₹ 67.00
Deferred income tax ₹ 67.00 ₹ 67.01 ₹ 67.01 ₹ 67.02 ₹ 67.03
Other
TOTAL LONG-TERM LIABILITIES ₹ 90.00 ₹ 101.01 ₹ 112.01 ₹ 123.02 ₹ 134.03
OWNER'S EQUITY
Owner's Investment ₹ 1,150.00 ₹ 1,173.00 ₹ 1,196.46 ₹ 1,220.39 ₹ 1,244.80
Retained Earnings ₹ 1,500.00 ₹ 1,650.00 ₹ 1,815.00 ₹ 1,996.50 ₹ 2,196.15
Other ₹ 850.00 ₹ 850.68 ₹ 851.36 ₹ 852.04 ₹ 852.72
TOTAL OWNER'S EQUITY ₹ 3,500.00 ₹ 3,673.68 ₹ 3,862.82 ₹ 4,068.93 ₹ 4,293.67

TOTAL LIABILITIES AND OWNER'S EQUITY ₹ 3,675.00 ₹ 3,885.69 ₹ 4,098.83 ₹ 4,343.95 ₹ 4,595.70

FINANCIAL RATIOS 2024 2025 2026 2027 2028


Debt Ratio 0.06 0.06 0.07 0.07 0.08
Current Ratio 27.84 22.33 20.99 18.00 17.15
Working Capital ₹ 2,281.00 ₹ 2,368.17 ₹ 2,478.17 ₹ 2,584.04 ₹ 2,713.91
Assets-to-Equity Ratio 0.89 0.90 0.91 0.93 0.92
Debt-to-Equity Ratio 0.05 0.06 0.06 0.07 0.07
=> Projected
Cash flow Statement - USD Millions
Particulars 2024 2025 2026 2027 2028
Operating Cash Flow
Net Earnings (55) (7) 78 159 748
Plus: Depreciation & Amortization 38 39 39 39 39
Less: Changes in Working Capital 910 1,702 775 903 827
180,000
Cash from Operations (927) (1,670) (658) (705) (40)
160,000

Investing Cash Flow 140,000


Investments in Property & Equipment 15,000 15,000 15,000 15,000 15,000 120,000
Cash from Investing 15,000 15,000 15,000 15,000 15,000 100,000
80,000
Financing Cash Flow 60,000
Issuance (repayment) of debt - (25,000) (20,000) - - 40,000
Issuance (repayment) of equity 170,000 - - - - 20,000
Cash from Financing 170,000 (25,000) (20,000) - - -
1 2
Net Increase (decrease) in Cash 154,073 (41,670) (35,658) (15,705) (15,040)
Opening Cash Balance - 154,073 112,403 76,745 61,041
Closing Cash Balance 154,073 112,403 76,745 61,041 46,001
,000
,000
,000
,000
,000
,000
,000
,000
,000
-
1 2 3 4 5
HR - Employee Payroll
Serial No. Job Position No. of employees in position Salary per annum
CEO 1 ₹ 2,000,000.00
Supervisory Management
1 Chief Operating Officer 1₹ 1,500,000.00
2 Chief Financial Officer 1₹ 1,700,000.00
3 Chief Human Resource Officer 1₹ 1,300,000.00
4 Chief Marketing Officer 1 ₹ 1,000,000.00
5 Chief Business Development Officer 1₹ 1,150,000.00
6 Chief Communications Officer 1 ₹ 950,000.00
7 Chief Technological Officer 1₹ 1,000,000.00
8 Chief Security Officer 1 ₹ 900,000.00
9 Chief Customer Services Officer 1 ₹ 1,150,000.00
Operative Management
10 Head of Recruitment 1 ₹ 800,000.00
11 Head of Training and Development 1 ₹ 700,000.00
12 Head of Operations 1 ₹ 600,000.00
13 Head of Finance 1 ₹ 900,000.00
14 Head of Customer Relations 1 ₹ 650,000.00
15 Head of Logistics and Transportation 1 ₹ 700,000.00
16 Head of Technological Assistance 1 ₹ 600,000.00
17 Head of Warehousing 1 ₹ 500,000.00
18 Head of Vendor Contracts 1 ₹ 550,000.00
19 Head of Security 1 ₹ 600,000.00
20 Head of Packaging 1 ₹ 800,000.00
21 Head of Legal and Compliance 1 ₹ 650,000.00
Lower-level Management
1 HR Team 10 ₹ 520,000.00
2 Marketing Team 25 ₹ 480,000.00
3 Public Relations Team 15 ₹ 500,000.00
4 Finance Team 20 ₹ 600,000.00
5 Business Development Team 42 ₹ 550,000.00
6 Finance Advisory Team 20 ₹ 580,000.00
7 Customer Relations Team 30 ₹ 450,000.00
8 CSR Outreach Team 15 ₹ 400,000.00
9 Service Management Team 30 ₹ 490,000.00
10 Vendor Relations Team 25 ₹ 470,000.00
11 Legal Team 15 ₹ 520,000.00
12 Supply Management Team 50 ₹ 500,000.00
13 Technological Assistance Team 12 ₹ 480,000.00
14 Warehousing Team 40 ₹ 510,000.00
15 Packaging Unit Floor Manager 75 ₹ 500,000.00
16 Logistics and Delivery Team 55 ₹ 490,000.00
Ground Level Staff
1 Warehouse Employees 1000 ₹ 300,000.00
2 Security Team 250 ₹ 270,000.00
3 Supply Team 150 ₹ 320,000.00
4 Customer Service Team 100 ₹ 250,000.00
5 Vendor Service Team 50 ₹ 260,000.00
6 Packaging Unit Workers 5000 ₹ 250,000.00
Total 7051 ₹ 30,390,000.00
Compensation and Benefits
Total Salary per annum Serial No.
₹ 2,000,000.00 1
2
₹ 1,500,000.00 3
₹ 1,700,000.00 4
₹ 1,300,000.00 5
₹ 1,000,000.00 6
₹ 1,150,000.00
₹ 950,000.00
₹ 1,000,000.00 Training and Development
₹ 900,000.00 Serial No.
₹ 1,150,000.00 1
2
₹ 800,000.00
₹ 700,000.00
₹ 600,000.00 Recruitment
₹ 900,000.00
₹ 650,000.00 Serial No.
₹ 700,000.00 1
₹ 600,000.00 2
₹ 500,000.00 2
₹ 550,000.00 3
₹ 600,000.00
₹ 800,000.00
₹ 650,000.00 Employee and Labour Relations
Serial No.
₹ 5,200,000.00 1
₹ 12,000,000.00 2
₹ 7,500,000.00 3
₹ 12,000,000.00 4
₹ 23,100,000.00
₹ 11,600,000.00
₹ 13,500,000.00 HR Budget
₹ 6,000,000.00 Serial No.
₹ 14,700,000.00 1
₹ 11,750,000.00 2
₹ 7,800,000.00 3
₹ 25,000,000.00 4
₹ 5,760,000.00
₹ 20,400,000.00
₹ 37,500,000.00
₹ 26,950,000.00

₹ 300,000,000.00
₹ 67,500,000.00
₹ 48,000,000.00
₹ 25,000,000.00
₹ 13,000,000.00
₹ 1,250,000,000.00
₹ 1,964,960,000.00
Compensation and Benefits
Particulars Amount per annum
Employee Salaries ₹ 1,964,960,000.00
Over-time Pay (5% of employee salaries) ₹ 98,248,000.00
Medical Insurance (Average annual premium of Rs. 7500 for a Rs. 3 lakh coverage) (Rs.
₹ 14,895,000.00
7500 x 1986)
Maternal and Infant Insurance (Average annual premium of Rs. 1500 for a Rs. 35,000
₹ 2,979,000.00
coverage)(Rs. 1500 x 1986)
Retirement Funding (10% of employee salaries) ₹ 196,496,000.00
Disability Insurance (2% of employee salaries) ₹ 39,299,200.00
Total ₹ 2,316,877,200.00

Training and Development


Particulars Amount per annum
Workshops and Conferences (1% of employee salaries) ₹ 19,649,600.00
Certification Programs (0.8% of employee salaries) ₹ 15,719,680.00
Total ₹ 35,369,280.00

Recruitment

Particulars Amount per annum


Job Advertisement (0.5% of employee salaries) ₹ 9,824,800.00
Employer Branding Events (1.5% of employee salaries) ₹ 29,474,400.000
Interview and Selection Process (0.1% of employee salaries) ₹ 1,964,960.000
Applicant Tracking (0.05% of employee salaries) ₹ 982,480.000
Total ₹ 42,246,640.00

Employee and Labour Relations


Particulars Amount per annum
Recognition Program (0.5% of employee salaries) ₹ 9,824,800.00
Performance Appraisal Software ₹ 1,500,000.00
Performance Incentives (2% of employee salaries) ₹ 39,299,200.00
Employment Satisfaction Administration (1% of employee salaries) ₹ 19,649,600.00
Total ₹ 70,273,600.00

HR Budget
Particulars Amount per annum
Compensation and Benefits ₹ 2,316,877,200.00
Training and Development ₹ 35,369,280.00
Recruitment ₹ 42,246,640.00
Employee and Labour Relations ₹ 70,273,600.00
Total ₹ 2,464,766,720.00
Discounted Cash Flow (DCF)

PV Of Unlevered Free Cash Flow


1 2 3 4 5
Particulars
2023 2024 2025 2026 2027 2028
PAT $ -6,420.00 $ 5,240.00 $ 5,868.80 $ 6,749.12 $ 8,031.45 $ 8,593.65
Depreciation (+) $ 1,120.00 $ 1,142.40 $ 1,199.52 $ 1,115.55 $ 1,171.33 $ 1,229.90
Capital Expenditure $ 1,280.00 $ 1,305.60 $ 1,279.49 $ 1,253.90 $ 1,228.82 $ 1,204.24
Unlevered Free Cash Flows $ -6,580.00 $ 5,076.80 $ 5,788.83 $ 6,610.78 $ 7,973.96 $ 8,619.31
Discount Rate (WACC) 6.79%
Discount Factors 93.64% 87.69% 82.11% 76.89% 72.00%
PV Of unlevered Free Cash Flow $ -6,580.00 $ 4,753.93 $ 5,075.94 $ 5,428.02 $ 6,130.93 $ 6,205.65
Total PV of Unlevered Cash Flow $ 21,014.47

Capital Structure WACC


Particulars Amount %Weight COC Weight*ATCOC Debt
Equity $ 215,000.00 20.55% 12.75% 2.62% % Debt
Debt $ 831,000.00 79.45% 7.00% 5.56% Cost of Debt
Total $ 1,046,000.00 100.00% 6.79% Tax Rate

Terminal Value of the business Equity Value


Growth Rate 6.09% % Equity
WACC 6.79% Cost of Equity
Terminal Value of Free Cash flow $ 1,303,362.86 Risk Free Rate
PV of Terminal Value $ 1,002,114.11 Beta
Market Risk Premium
Calculation of Enterprise Value
Enterprise Value $ 1,023,128.59 Debt + Equity
(-) Debt Capital $ 831,000.00 WACC
Cash $ 120,000.00
Equity Value $ 312,128.59
WACC WACC = (% Equity x Cost of Equity) + (% Debt x Cost of Debt x (1 -Tax rate))
831,000.00 Cost of Equity = Risk Free Rate + (Beta x (Expected Market Return - Risk Free Rate))
79.4%
7.00%
25.0%

215,000.00
20.6%
12.8%
4.5%
1.50
rket Risk Premium 5.5%

1,046,000.00
6.79%
Leveraged Buyout Model (LBO) - [Company Name]
Assumptions

Entry ($MM) Financials Capital Structure Amount


LTM EBITDA 150 LTM Financials Bank Debt 4.0x
EBITDA Multiple 10.0x Revenue 1000 Senior Notes 2.0x
Enterprise Value 1,500 EBITDA 150
Existing Net Debt 550 D&A 50 For Reference
Equity Value 950 Capex 75 IRR
NWC 100
Fees & Expenses 75
Operating Assumptions
Exit ($MM) Revenue Growth 7.0%
EBITDA Multiple 10.0x YoY margin expansion 1.0%
Tax Rate 25.0%

Sources and Uses

Sources Uses
Amount xEBITDA % Capital Amount xEBITDA
Bank Debt
Senior Notes
Total Debt

Sponsor Equity

Total Sources

Financials

Operating Model Year 0 Year 1 Year 2 Year 3 Year 4


Revenue
% growth

EBITDA
% sales

EBIT
% sales

Interest

EBT
% sales

Taxes
% tax rate

Net Income
% sales

Cash flow Items Year 0 Year 1 Year 2 Year 3 Year 4


D&A
% sales

Net Working Capital


% sales
Change in Net Working Capital

CapEx
% sales

Levered Cash Flow Year 0 Year 1 Year 2 Year 3 Year 4


Net Income
D&A
CapEx
Change in NWC
Levered Cash Flow

Debt Schedule

Year 0 Year 1 Year 2 Year 3 Year 4


Bank Debt
Beginning Balance
Interest
Paydown
Ending Balance

Sr. Notes
Beginning Balance
Interest
Paydown
Ending Balance

Total Debt
Beginning Balance
Interest
Paydown
Ending Balance

IRR

EBITDA at Exit
Exit Multiple
Enterprise Value
Net Debt
Sponsor Equity Value

Sponsor Equity at Entry

MOIC
IRR
Cost
6.0%
12.0%

ference
0.0%

% Capital

Year 5
Year 5

Year 5
Year 5
I
Internal Rate of Return (IRR)
($ in millions) Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
12/31/21 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26

Cash Inflows / (Outflows) IRR MoM Step Function $25


Exit Year 1 29.4% 1.3x ($85) $110
Exit Year 2 26.0% 1.6x ($85) -- $135
Exit Year 3 23.4% 1.9x ($85) -- -- $160
Exit Year 4 21.4% 2.2x ($85) -- -- -- $185
Exit Year 5 19.8% 2.5x ($85) -- -- -- -- $210

Multiple on Invested Capital (MOIC)


($ in millions) Year 0 Year 1 Year 2 Year 3 Year 4

Cash Inflows / (Outflows), net ($100) $30 $45 ($14) ($20)


% Recovery of Initial Investment Step 50.0% -- 100.0% 150.0% 200.0% 250.0%

LBO Returns Schedule IRR MOIC 12/31/21 12/31/22 12/31/23 12/31/24 12/31/25
Exit Year 1 0.0% 1.0x ($100) $100
Exit Year 2 22.5% 1.5x ($100) -- $150
Exit Year 3 26.0% 2.0x ($100) -- -- $200
Exit Year 4 25.7% 2.5x ($100) -- -- -- $250
Exit Year 5 24.6% 3.0x ($100) -- -- -- --
Year 5

$6
300.0%

12/31/26

$300
Debt Schedule - [Company Name]
Loan amount (in USD million) 20,000
Annual Payment Interest Portion Principal Portion Outstanding Balance
Year 1 110 17.72 92.28 -908
Year 2 110 16.08 93.92 -814
Year 3 110 14.42 95.58 -718
Year 4 110 12.72 97.28 -621
Year 5 110 11.00 99.00 -522
Year 6 110 9.25 100.75 -421
Year 7 110 7.46 102.54 -319
Year 8 110 5.64 104.36 -214
Year 9 110 3.80 106.20 -108
Year 10 110 1.91 108.09 -0
Total 1,100 100 1,000

Effective interest rate 7.50%


Investment Portfolio
Sl. No Investment Amount Growth Rate (YoY) Interest Earned Final Amount (Post Exit) Inv
1 XYZ 10000 22% 2200 12200 14000
2 10000 2% 200 10200
12000
3 10000 13% 1300 11300
4 10000 12% 1200 11200 10000
5 10000 22% 2200 12200 8000
6 10000 22% 2200 12200
6000
7 10000 22% 2200 12200
8 10000 22% 2200 12200 4000

9 10000 22% 2200 12200 2000


10 10000 18% 1800 11800 0
Total 100000 17700 117700 XYZ
Investment Portfolio
14000

12000

10000

8000

6000

4000

2000

0
XYZ

Column G Column H
Sharpe Ratio Sortino Ratio
Month Returns Excess Return
Expected Portfolio Return (Rp) 25.0% 1 0.89% 0.64%
Risk-Free Rate (Rf) 5.5% 2 0.12% -0.13%
Standard Deviation of Portfolio (σp) 8.0% 3 -0.20% -0.45%
4 1.00% 0.75%
Sharpe Ratio 2.44x 5 -0.02% -0.27%
6 2.00% 1.75%
7 3.00% 2.75%
8 1.00% 0.75%
9 -0.30% -0.55%
10 1.00% 0.75%
11 1.02% 0.77%
12 -1.00% -1.25%
no Ratio
Negative Excess Returns
0.00% Min Acc Return 0.25%
-0.13% Downside Risk 0.0042399882075
-0.45% Av Excess Return 0.46%
0.00% Sortino Ratio 1.0829432635004
-0.27%
0.00%
0.00%
0.00%
-0.55%
0.00%
0.00%
-1.25%
Accretion / Dilution Analysis

Acquirer Target

Acquirer
Current share price $750.00
Diluted shares outstanding 310,000,000
Earnings per share (EPS) forecast $25.00
Acquirer shares issued in transaction

Target
Pre-deal share price $25.00
Offer price per share $40.00
% Offer Premium 62.5%
Shares outstanding 315,000,000
Offer value $12,600,000,000
Earnings per share (EPS) forecast $2.00

Accretion / dilution analysis


Implied standalone net income
Implied standalone pretax income

Pro forma pretax income - unadjusted


Less: Interest expense from new deal debt
Less: Incremental D&A expense
Less: Deal fees
Less: Financing fees amortization
Plus: Synergies
Pro forma pretax income - adjusted

Pro Forma Net Income


Pro Forma Shares Outstanding
Pro Forma EPS
Acquirer standalone EPS
Accretion / Dilution per share
Accretion / Dilution %

Sensitivity analysis
Accretion / dilution sensitivity at various % consideration and $ offer price per share assumptions
% stock:
$0.00 0%
Offer price: $30.00 $0.00
$40.00 $0.00
$70.00 $0.00
Pro Deal Assumptions
Forma (Year 1)

Deal date:

Form of consideration <--Assume cash portion financed entirely by new acquirer debt for simplicity of this exercise.
% Stock 50.0%
% Cash 50.0%

Tax rate: 40.00%

Deal debt:
Acquirer new borrowing $6,300,000,000
Term of loan 5 years
Interest rate on new debt 5.0%
Financing fees $2,000,000
Annual financing fee amortization $400,000

Synergies: $100,000,000

Asset write-ups:
Book value of target assets $20,000,000
Fair market value of target assets $25,000,000
Asset write-up $5,000,000
Useful life 10 years
Incremental D&A expense $500,000

Deal fees: $5,000,000 Advisory fees in M&A


50% 100%
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
mplicity of this exercise.
Marketing Budget
Projected Subtotal ₹ -
CAMPAIGN TYPE PROJECTED COMMENTS
SUBTOTAL
National Marketing SUBTOTAL ₹ -
Banner Ads

Local Marketing SUBTOTAL ₹ -


Newspaper
In-Store Marketing
POP

Public Relations SUBTOTAL ₹ -


Public Events
Sponsorships
Press Releases
Webinars
Conferences
Client Events

Content Marketing SUBTOTAL ₹ -


Sponsored Content
Landing Page
White Papers / ebooks

Social Media SUBTOTAL ₹ -


Twitter
Facebook
Pinterest
Instagram
Google+
LinkedIn
Online SUBTOTAL ₹ -
Blog
Website
Mobile App
Mobile Alerts
Email Newsletter

Advertising SUBTOTAL ₹ -
Online
Print
Outdoor
Radio
Television

Web SUBTOTAL ₹ -
Development
Pay-Per-Click Marketing
SEO

Market Research SUBTOTAL ₹ -


Surveys
Impact Studies

Sales Campaigns SUBTOTAL ₹ -


Campaign A
Campaign B
Campaign C
Campaign D
Campaign E

Other SUBTOTAL ₹ -
Premiums
Corporate Branding
Business Cards
Signage

You might also like