It will be my pleasure to provide you the answer, if you could send data thanks.
I included the attachment in my question.
Let me know if this helps
The figures for all 5 years will remain the same as there is no details are given, moreover, it may be assumed that any change due to inflation is offset by cchange in revenues and expense.
I understand that, but can you please give a budget with each scenario...the current, hi-tech, and broker using the info in the spreadsheet?
Click here for solution
Can u not combine the hi-tech and broker option? I would like them broken out individually if possible.
Are you using the data provided from the spreadsheet I attached
Nevermind about breaking them out
I see that the way you did it is the way it is supposed to be
However, it doesn't appear that the data sent/attached was used to generate these numbers. The beginning cash balance should reflect the data in the attached spreadsheet
The data is almost the same with slight difference which I have adjusted ad attaching the revised solution, the 3rd cash flow is for high tech and borker combined option.
Click here for revised solution
Here's another example...that I'm comparing to the solution you are posting. Is your solution a shorter less detailed version?
Sorry...here's the attachment
The cash flow you have attached is not as per data you have provide but my excel sheet which I have provided matches your data, you can cross check it, add the net earnings before tax and depreciation and then deduct tax on earnings like this for current option 42577+50000-17882 = 74695 which is equal to surplus shown on my excel sheet, thanks.