Australian Tax (Excel Model) - Mortgage vs Salary Sacrifice
Worldwide
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- ExpertExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
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
- United KingdomLondon10:16 AM
- $7.5K total spent18 hires, 0 active
- 20 hours
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers 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