Percent of Sales Forecast Pro Forma Income Statement

[@martinbrezina7811]

This video helped me a lot with my corporate finance exam. Thank you sir, you are a gentleman and a scholar!

[@lyeargin]

In what video do you do the sales?

[@lisamarr9116]

When forecasting, do you subtract projected Sales Returns & Allowances to determine projected year-end sales?

[@profbeav]

Yes.

[@jademiller5384]

I was wondering, since you did a 2 year average, if you were doing forecast for multiple years, would the formula need to change a bit if you did forecasts for year 2022, 2023, etc?

[@profbeav]

Generally, the more real-world (i.e., actual, not forecasted) data the better. If it is a fixed cost, then no; for variable costs, that would not be a bad idea.

[@dustincrum4104]

I’m struggling with creating a Pro Forma for the first time for a class assignment I have and was hoping that you could be of assistance?

[@profbeav]

I generally do these videos for free...check out how I made the other financial statements and feel free to reach out and let me know if you are struggling with something specific. Thanks!

[@aayushipatel6196]

can you do a video on calculating total revenue with total revenue, operating income, and operating margin with percentage?

[@profbeav]

The procedure for what you are describing is the same as the one I did here...if you have something in mind or an example please share and I will consider it for a future video.

[@Sarah-vk4qq]

This is far too complicated, there is a far easier way without having to use the "average" formula in excel

[@profbeav]

Do tell!