View Single Post
  #1   Report Post  
dukes
 
Posts: n/a
Default How do I calculate pro-rata formulas?

I have a spreadsheet that I need to complete for a class assignment. I am
new to Excel and would appreciate any help. It consists of 4 columns.
Columns look like this: beginning budgeted amount, pay raise,
improvements, ending budgets.

I have the beginning budgets for each program and the pay raise and
improvements dollar amount. How do I pro-rate the pay raise and improvements
to each program.