How to Prepare Projected Balance Sheet

Projected balance sheet is not actual but it shows the estimation of total assets and total liabilities of any business. You may need to prepare projected balance sheet, if you have applied for bank loan of your new project or you are interested to buy new fixed assets. For preparing projected balance sheet, you can use ms excel. Following steps will be helpful for preparing projected balance sheet.

1st Step : Calculate cash in hand and cash at bank 

If you have no any book record of your cash, you can show cash in hand after checking your cash balance in business's pocket. You can check also available balance at bank. Both will be your current assets in balance sheet.

2nd Step : Calculate Fixed Assets 

See everything around you. Make the list of assets whose benefits are you taking more than one year. Check its price from cash memo or past bills. Try to calculate time of its using. If you have used it for 3 years. Its value will surely decrease due to depreciation. Charge 10% to 20%  per year on every fixed asset up to used period with any method of depreciation. Now, you will get current cost of fixed asset. Show it in the asset side of balance sheet.

3rd Step : Calculate Value of Financial Instruments 

If you invested your money in shares, bonds and other financial instruments. Write its purchase price. If it has decreased, then you can also show current market price of financial instruments.

4th Step : Calculate your Business Earning

If you have not made profit and loss account. You can just compare your all expenses and your all incomes. If  your incomes are more than your expenses, it will be your net profit. It will be transfer to liability side of balance sheet. You should only deduct expenses whose benefits, you have obtained in one year.

5th Step : Calculate Business's Liabilities

In these liabilities, you can add bank loan, secured loan and other loans. This will be added in liability side of projected balance sheet.

3rd Step : Calculate Business's Capital 

Business's capital, you can calculate by subtracting outside liabilities from total assets. This will also add in the balance sheet in liabilities side.

Following is the proforma of projected balance sheet

Related : How to Audit Balance Sheet


Comments on this Website: 1

Share above Content to Your Friends

Meet Your Teacher

Vinod Kumar Prof. Vinod Kumar has received the post graduate degree in Commerce from ... read more »


access account accountant Accounting accounting definitions accounting ebook Accounting education accounting procedure accounting process outsourcing Accounting Software advance advertising africa Amalgamation amendments announcements Annuity assets audit auditing Australia B.Com. balance sheet bank Bank reconciliation banking basic accounting BBA benefits best bill black money blog bloggers book keeping bookkeeping Branch Accounting - full tutorial budget Budget variance business businessman CA calculator canada capital capital budgeting career cash cash book cash flow statement Chiense children china class coaching coins college commerce commerce students company computer computer accounting conference Contact vinod kumar corporate accounting cost cost accounting cost center cost centre CPA credit credit card cs currency data Debit and credit debit cards debt debtor degree depletion depreciation documents dollar domain Downloads Dubai e-accounting earning education Education Loans email employee EPF ERP euromoney examination excel excise duty expenses facebook factor of loan fans feature fifo FII fiji finacle finance Financial financial accounting fire insurance flickr flow forensic forex formula france fraud free fun function fund GAAP GDP gdr germany gold goodwill goodwill accounting google google apps google apps google base google buzz google calendar Google docs google finance google fusion tables google talk govt. GST guide health Hindi Hindi Language history holding company How to treat FBT in Tally 9 HRA ICAI ICAWI ICICI Bank IFRS income income statement Income Tax India indian railway Indonesia inflation inflation accounting infographics information inspiration insurance insurance accounting interest international Internet Introduction of Tally 9 inventory investment invoice IT Japan Job costing journal entries Kalculate keyboard kindle kuwait laptop law LBT learning lease lecture ledger leducation Leverage Analysis liabilities lifo linkedin loan logical point loss loss of profit M.Com. m.phil malaysia management accounting manual accounting manufacturing account market marketing mastercard material MBA MCA media migration mobile money ms word ms. excel multi currency in tally 9 Multicurrency Accounting mutual fund national security new and sacrifice ratio new york times new zealand news NGO nonprofit-accounting North Georgia Mountains NPV NSE odbc office oman online application online accounting otcei pakistan parents pay pal pdf pie chart pie chart of income pnb podcast ppf presentation price privacy policy prize money prof. vinod kumar profit profit and loss account project management provision purchase puzzles quickbooks Quote quotes quotes of svtuition rating agency ratio analysis RBI readers real estate rectification of errors remote control reports reserves responsibility accounting retirement revenue Revenue reserves review risk rupees salary sale saudi arabia saving sbi scholarship school SEBI security service tax share share trading Shares shri lanka singapore sms social accounting society solution South Africa stock stock exchange structure student students study subsidiary company svtuition swiss bank tally tally 9 Tally 7.2 Tally 9 Tally.ERP 9 tanzania tax Tax Accounting TDS teacher teaching technology test testimonial testimonials thailand tips trading trading on equity transaction trend trial balance tuition twitter UAE UGC - NET Commerce UK United Arab Emirates university usa valuation VAT Video Voucher and vouching wikipedia working capital youtube
Accounting Education: How to Prepare Projected Balance Sheet
How to Prepare Projected Balance Sheet
Accounting Education
Not found any lecture VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES Lectures View All RECOMMENDED FOR YOU Category ARCHIVE SEARCH ALL Lectures Not found any lecture match with your request, please help to write it and send it to our email at for making this website free accounting and finance encyclopedia. Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock