Forum Discussion

Phillip6183's avatar
Phillip6183
Copper Contributor
Oct 05, 2022

Need help with fixing some formulas...

I have a 10-year income/expense budget projection for a condo-hotel operation.  There is a 60-40 split of rental revenue after expenses between the hotel owner and the individual owners of each condo...
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Oct 06, 2022

    Phillip61831665 

    E47 contains: 

    =(E45-E51)*'Condo Unit ProformaAssumptions'!$E$14

    E49 contains:

    =(E45-E51)*'Condo Unit ProformaAssumptions'!$E$13

     

    The file is in Viewing mode. When I change it to Edit mode external links are removed and can not see the Assumptions sheet. But I guess E14 in that sheet contains 60% and E13 contains 40%. Just change it to 40% and 60%.

     

Share

Resources