Australian Tax (Excel Model) - Mortgage vs Salary Sacrifice

Posted 2 days ago

Worldwide

Summary

Hello, Seeking an Excel and Australian tax specialist to review and correct a simple ten-year model comparing no salary sacrifice versus additional super contributions funded partly by an interest-only mortgage, including tax, Division 293, contribution limits, investment growth, cash-flow impact and the overall financial winner. With ability to change the growth rates, super top ups, income etc. Option A - Base Case Before Salary Sacrifice Option B - Salary Sacrifice + Mortgage to help cover living costs. Difference Base vs Salary Sacrifice Issues include: Treatment of the Division 293 contributions - Cells C22, C23 and C33, C34. Tax saving C27 and C36 – Is that saving simply included in the net salary figures C35 and C26. Is C45 correct? Needs a thorough check of the methodology, keeping in mind the following which would be good to add: - most mortgage interest will not be accrued as there will be cash against it in an off set account. - saved income (Option A) ‘earned’ by no salary sacrifice hasn’t been grown at a %. - no yearly cashflow / IRR or NPV - Anything else you spot to improve the models accuracy. Regards James

  • $150.00

    Fixed-price
  • Expert
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Accounting
Microsoft Excel
Activity on this job
  • Proposals:10 to 15
  • Last viewed by client:2 days ago
  • Interviewing:
    5
  • Invites sent:
    15
  • Unanswered invites:
    9
About the client
Member since May 26, 2009
  • United Kingdom
    London10:16 AM
  • $7.5K total spent
    18 hires, 0 active
  • 20 hours

Explore similar jobs on Upwork

Financial Modeling
Financial Projection
Company Valuation
Financial Analysis
PowerPoint Presentation
Financial Modeling

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo