Assistance with Spreadsheet

Discussion in 'Property Information Resources & Tools' started by Indmr, 6th Feb, 2019.

Join Australia's most dynamic and respected property investment community
Tags:
  1. Indmr

    Indmr Active Member

    Joined:
    28th Jan, 2019
    Posts:
    43
    Location:
    Australia
    Hello Everyone,
    Could I please request some expert assistance with excel spread sheet. Firstly great work and thanks for sharing. I got this from "Excel Sheet".
    Among so many to choose from I am working on 11 IP Calculator, I find it has all necessary information one need to understand financial feasibility. I am having difficulty understanding some of the input data and output its populating.

    I am just trialling and checking some random figures, not sure if the results are coming accurate? Is it me or the excel sheet? Attached Spread Sheet.

    Investment Property Price - $4,50,000
    Deposit - $54,000(12%)
    Interest Rate - 5%
    Rent - $350 PW
    My Income - $60,000
    Date of Purchase - 1/08/2019
    Capital Growth - 10%

    Is the loan amount is $4,23,449?

    Just to confirm the excel sheet only calculate Interest only? I have tried calculating interest on few bank websites the amount doesn't come same.

    I am good with excel sheets however not understanding the reason behind some of the formulas.
    Below are some snippets from the excel sheet.

    [​IMG]

    [​IMG]

    Sorry guys to bother, I am new to all this and learning so much from all you!!
    Thanks in advance.
     

    Attached Files:

  2. DevD

    DevD Well-Known Member

    Joined:
    3rd Apr, 2022
    Posts:
    61
    Location:
    Melbourne
    did you get anywhere with this ?