Financial Template

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 18

Company: ________Sdn Bhd

Income Statement - Summary of Years 1 to 5


This template provides a pro forma income statement. Please note that this type of layout is for management purposes only, rather
than for the year-end filing of accounts. You can customize the form by changing the row labels or adding rows.
To add a row, select one of the rows labeled "Other," click Insert on the Excel menu bar, and then click Rows. You will then need to
use the fill handle (see Excel Help) to fill in the formula in the "Totals" column. The cells displaying zeros contain formulas to perform
automatic calculations on your data. Do not enter data into these cells because doing so will erase the formulas in them.

Note: Please make necessary adjustments to produce a 12 months statement for the first year of your business operations

Income Statement - Summary of Years 1 to 5

Year 1: Year 2: Year 3: Year 4: Year 5:

Sales
Sales
Other
Total Sales 0 0 0 0 0

Less Cost of Goods Sold


Materials
Labor
Overhead
Other
Total Cost of Goods Sold 0 0 0 0 0

Gross Profit 0 0 0 0 0

Operating Expenses
Salaries and wages
Employee benefits
Payroll taxes
Rent
Utilities
Repairs and maintenance
Insurance
Travel
Telephone
Postage
Office supplies
Advertising
Marketing/promotion
Professional fees
Training and development
Bank charges
Depreciation
Miscellaneous
Other
Total Operating Expenses 0 0 0 0 0

Operating Income 0 0 0 0 0

Interest income (expense)


Other income (expense)
Total Nonoperating Income (Expense) 0 0 0 0 0

Income (Loss) Before Taxes 0 0 0 0 0

Income Taxes

Net Income (Loss) 0 0 0 0 0

Cumulative Net Income (Loss) 0 0 0 0 0


purposes only, rather
s.
You will then need to
ain formulas to perform
s in them.

ss operations

Totals

0
0
0

0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0

0
Company: ______Sdn Bhd

Balance Sheet - Summary of Years 1 to 5

This template provides a pro forma balance sheet. Please note that this type of layout is for management purposes only, rather
than for the year-end filing of accounts. You can customize the form by changing the row labels or adding rows.
To add a row, select one of the rows labeled "Other," click Insert on the Excel menu bar, and then click Rows. The cells
displaying zeros contain formulas to perform automatic calculations on the data you enter. Do not enter data into these cells
because doing so will erase the formulas in them.

Balance Sheet - Summary of Years 1 to 5


Opening Year 1: Year 2: Year 3: Year 4:

ASSETS

Current Assets
Cash
Marketable securities
Accounts receivable, net
Inventory
Prepaid expenses
Other
Total Current Assets 0 0 0 0 0

Long-Term Assets
Property, plant, and equipment
Less accumulated depreciation
Net property, plant, and equipment 0 0 0 0 0
Other long-term assets
Total Long-Term Assets 0 0 0 0 0

Total Assets 0 0 0 0 0

LIABILITIES AND SHAREHOLDERS' EQUITY

Current Liabilities
Short-term debt
Current maturities of long-term debt
Accounts payable
Income taxes payable
Accrued liabilities
Other
Total Current Liabilities 0 0 0 0 0

Long-Term Liabilities
Long-term debt less current maturities
Deferred income taxes
Other long-term liabilities
Total Long-Term Liabilities 0 0 0 0 0

Shareholders' Equity
Common stock
Additional paid-in capital
Retained earnings
Other
Total Shareholders' Equity 0 0 0 0 0

Total Liabilities and Shareholders' Equity 0 0 0 0 0


purposes only, rather
g rows.
ows. The cells
data into these cells

Year 5:

0
0

0
Company: ______Sdn Bhd
Cash Flow Forecast -12 Months

This template provides a pro forma cash flow forecast. Enter your figures in the month you realistically expect them to take place. Start by
labels or adding rows.
To add a row, select one of the rows labeled "Other," click Insert on the Excel menu bar, and then click Rows. You will then need to use th
displaying zeros contain formulas to perform automatic calculations on your data. Do not enter data into these cells because doing so will e

Note: Please make necessary adjustments to produce a cash flow forecast for the first five years of your business operations.

Cash Flow Forecast - 12 Months

Month: Pre-Start 1 2 3 4

Receipts
Cash sales
Collections from credit sales
New equity inflow
Loans received
Other
Total Receipts 0 0 0 0 0

Payments
Cash purchases
Payments to creditors
Salaries and wages
Employee benefits
Payroll taxes
Rent
Utiltities
Repairs and maintenance
Insurance
Travel
Telephone
Postage
Office supplies
Advertising
Marketing/promotion
Professional fees
Training and development
Bank charges
Miscellaneous
Owner's drawings
Loan repayments
Tax payments
Capital purchases
Other
Total Payments 0 0 0 0 0

Cashflow Surplus/Deficit (-) 0 0 0 0 0

Opening Cash Balance 0 0 0 0 0

Closing Cash Balance 0 0 0 0 0


ect them to take place. Start by entering the definite amounts first. You can customize the form by changing the row

ws. You will then need to use the fill handle (see Excel Help) to fill in the formula in the "Totals" column. The cells
ese cells because doing so will erase the formulas in them.

business operations.

5 6 7 8 9 10 11 12 Totals

0
0
0
0
0
0 0 0 0 0 0 0 0 0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0

0 0 0 0 0 0 0 0
Company: ______Sdn Bhd

Break-Even Analysis

Enter the relevant data from your income statement to calculate your break-even point (BEP). Vary the size of the
different inputs to analyze your BEP's sensitivity to rises or falls in sales or costs. You can customize the form by
changing the row labels or adding rows.
To add a row, select one of the rows labeled "Other," click Insert on the Excel menu bar, and then click Rows. The
cells displaying zeros contain formulas to perform the calculations on your data. Do not type into these cells because
doing so will erase the formulas in them. Click on the "Example" tab to see a completed version of this worksheet.

Break-Even Analysis

Number of Months

CALCULATE YOUR CONTRIBUTION MARGIN

Projected Sales

Less Variable Expenses


Materials
Labor
Variable overhead
Other
Contribution Margin $0

Contribution Margin Ratio 0%

CALCULATE YOUR FIXED EXPENSES

Fixed Expenses
Salaries and wages
Rent
Utilities - fixed portion
Repairs and maintenance
Insurance
Travel
Telephone
Postage
Printing
Advertising
Marketing/promotion
Professional fees
Training and development
Bank charges
Depreciation
Miscellaneous
Interest income (expense)
Other
Total Fixed Expenses $0

Break-Even Sales $0

Monthly Break-Even Sales $0

Profit During Period $0


Company: ______Sdn Bhd

Summary of Key Ratios - Years 1 to 5

This template will automatically calculate your key operating ratios, based on the data you enter from your income
statement and balance sheet summaries of years 1 to 5.
Fill in the appropriate cells in the "Data Collection" section. The cells displaying zeros contain formulas to perform
the calculations on your data. Do not type into these cells because doing so will erase the formulas in them.

Summary of Key Ratios - Years 1 to 5

Year 1 Year 2 Year 3 Year 4

DATA COLLECTION

Balance Sheet
Cash
Marketable securities
Accounts receivable, net
Total current assets
Total long-term assets
Total current liabilities
Total long-term liabilities
Total shareholders' equity

Income Statement
Total sales
Gross profit
Total operating expenses
Income (loss) before taxes
Net income (loss)

KEY RATIOS

Profitability Ratios
Return on equity 0% 0% 0% 0%
Return on assets 0% 0% 0% 0%
Return on sales 0% 0% 0% 0%
Gross profit margin 0% 0% 0% 0%
Asset turnover ratio 0% 0% 0% 0%
Leverage and Liquidity Ratios
Current ratio 0 0 0 0
Quick or acid test ratio 0% 0% 0% 0%
Leverage ratio 0% 0% 0% 0%
Long-term debt ratio 0 0 0 0
Debt to equity ratio 0 0 0 0

VIABILITY ANALYSIS (NPV, IRR, PAYBACK PERIOD)

Income (loss) before taxes 0


Interest expense 0
Earnings before interest and taxes (EBIT) 0 #VALUE! #VALUE! #VALUE! #VALUE!
Capital Investment (loan + equity)
EBIT-Capital Investment ### ### ### ### ###

NPV (net present value) #VALUE!


IRR (internal rate of return) #VALUE!
PAYBACK PERIOD
Year 5

0%
0%
0%
0%
0%
0
0%
0%
0
0

#VALUE!

###

You might also like