Build on current excel list - help

Discussion in 'Property Information Resources & Tools' started by Annie33rd, 29th Mar, 2022.

Join Australia's most dynamic and respected property investment community
  1. Annie33rd

    Annie33rd Well-Known Member

    Joined:
    4th Mar, 2022
    Posts:
    58
    Location:
    Sydney
    I am swimming in excel sheets at the moment - trying to find something relatively simple as some look super complicated.

    I am not sure how to attach things to threads as i can't see any attach files buttons here but i have uploaded a screenshots of the Positive Real Estate sheet that i really like but it is doesn't have a couple of things that i would like and it is locked so i can't edit some parts of it.

    Can anyone recommend a sheet that has the ability to model existing numbers at different interest rates...so 3/5/7%? And then also have the ability to select a period where repayments are IO and then switch to P&I. This sheets has either IO or P&I but i would like to see the switch visually at say year 5 to see by how much the rent needs to be raised / or how much of a loss the property would be making?

    Sheet 1
    Sheet 2
     
    Annie33rd, 29th Mar, 2022
    #1
  2. Robin M.

    Robin M. Active Member

    Joined:
    11th Apr, 2022
    Posts:
    29
    Location:
    Australia
    pm sent.
     
    Robin M., 1st May, 2022
    #2
  3. Peter_Tersteeg

    Peter_Tersteeg Mortgage Broker Business Member

    Joined:
    18th Jun, 2015
    Posts:
    8,171
    Location:
    03 9877 3000
    To calculate P&I repayments, use the PMT Excel function.
     
    Peter_Tersteeg, 1st May, 2022
    #3
    craigc likes this.