the business plan of this small family invented business is already done, but I can't balance it!
BALANCE SHEET: it has to be balanced monthly, so lines 29 and 37 have to be exactly the same!
SUMMARY: in summary sheet, the balance sheet annual has to be balance, so lines 64 and 72 have to be exactly the same.
INTRODUCTION&ASSUMPTIONS: this sheet contains my assumptions for the costs that I used, so in the profit and loss, cash flow and balance sheet the data come from “introduction&assumption” sheet. You can see the all the costs involved in “introductions and assumptions” column P to T.
SALES FORECAST: it is correct and how the professor wants
RATIOS: it is correct and how the professor wants. The sheet will be updated once the sheet SUMMARY will be balanced.
BALANCE SHEET PROFE: is the model that professor gave us to do the balance sheet monthly, so he wants the sheet “ BALANCE SHEET” as his model that you can see in BALANCE SHEET PROFE.
GRAPHS: check if they are correct once you have balanced the balance sheet and summary. Add others graphs that can be useful to understand the overall situation trend.
**** PROFIT & LOSS, CASH FLOW AND BALANCE SHEET HAVE TO BE LIKE I HAVE DONE, I MEAN FOR THE STRUCTURE, BECAUSE PROFESSOR WANTS LIKE THIS! Change whatever you want to obtain a balance sheet and summary balanced, but not the structure of the 3 sheets aforementioned, because professor wants like this.
I am currently an auditor, i have expertise to prepare the Financial statements ( Profit or loss, Balance sheet and cash flow). Once u provide me your assumption for all the heads (elements) of these financial statement. I could prepare the financial statements as required by you.
I would try to give your financial statement in better shape , by disclosing the policies as revenue recognition and other (compliance to IFRS).
I would submit the project back to you within 48 hours after your accepting my proposal.
Thanks for your time and consideration.
Regards,