Financial Planning & Forecasting - Spreadsheet Modeling

This videos shows an example of how to perform financial planning and forecasting for a business.

[ejiroobodo]

A Nigerian brother doing something beautiful, thanks Obi

[PatObi]

Thanks all for your kind comments. Some have asked for the Excel file, which I think defeats the purpose of this presentation. To replicate the analysis, simply retype the input data and only the first column of data...takes no more than 5 minutes; and then perform the analysis.

[aruva]

Thank you so much Pat, I haven't seen any other video here explaining Fp and a well than this.

[IrfanAliTaj]

How can I calculate "G" if I am doing manually .

[mohammedrezakhan]

Nice presentation, keep it up. Thank you very much.

[derekallan]

Hello Pat. Great lesson!
Question: If interest rate on all debt is 12% and total debt is $20, 000 why is the interest expense $510 for both the current and forecast year? Thanks

[gladnessregoya]

Hello is it okay that forecasted balance sheet is not balance?

[OmarAl]

Would it be helpful to calculate the net present value of the AFN which is 754, at 0, 125 borrowing rate?

Perhaps we can have better understanding of the cost needed to borrow the required AFN.

Best

[vimode]

Could you share this template? Thank you for the video.

[bibekadhikari]

Sir how can i got that excell sheet format

[TolulopeOlamideAjayi]

Thanks Pat. About to start a new media company. this was quite useful.

[ekikondingibabeyene]

Pat could you please share the excel file u used. Thnaks a million

[thoeunsavoeun]

Could you share with me the file of this show? Thank you so much in advance.

[excaliberx]

Your percentages in the top left corner. How did you come to those percentages?

[ericschraud]

This is great. I am doing see forcasting for a turnaround company now. Happy to make our own but do you happen to have a template?

[thaolai]

can you share the excel sheet for me?thank you.

[afmfawzy]

Very useful thanks need more videos about forecasting and budgeting and plz add the excel file

[monkmonk]

Hi Pat. Greetings from Africa. Great Video. Thank you. Where can I upload the data Excel? I want to reedit the exercise by myself. Thank you.

[gavinhoffmann]

Can you please upload the excel document that you used. That would be huge!!
Thank you so much for doing this.

[Mad]

Great explanation... Can you please share the excel copy of this??