Pro Forma Income Statement Percent of Sales (Excel 2016)

Using our wired income statement from before.

[@daraormon3229]

Where would you get the operating revenue figure on a future year? For example, 2022? This looks like you calculated based on a prior year.

[@brianhenry4754]

If you were building Proformas for a company you would be using internal revenue projections typically.

[@kamalassi2606]

can you send the exel file ?

[@16deej]

How do you lock in excel?

[@brianhenry4754]

F4 on a PC. Or Command+T on a Mac. You can also just type the dollar signs in.