Find Jobs
Hire Freelancers

Real Estate Mortgage Math Problem - Excel Spreadsheet

$250-750 CAD

Closed
Posted about 5 years ago

$250-750 CAD

Paid on delivery
Budget TBD but an entry is required so I put the minimum to be able to move the screens forward - need proposal please. Deliverable: Re-usable spreadsheet that with input can answer/calculate the following common questions from clients: Example 1: client wants to buy home for $1.2M, put 20% down leaving a $960k mortgage only $750k of which is deductible. Tax effect of not being able to fully deduct larger mortgage. Example 2: same client, same situation, what is the opportunity cost on the larger amount put down to get to that smaller (but deductible) mortgage of $750k. Assumes 7% growth, 2.6% inflation on the money if it was invested in markets vs. the home. Example 3) client can refi a rental property to pay off student loans at 6.5% but they give up a 3.5% mortgage for a 4.2% mortgage and the refi transaction costs - what's their breakeven point if they refi?
Project ID: 19247845

About the project

16 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average $334 CAD for this job
User Avatar
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$750 CAD in 10 days
4.9 (566 reviews)
8.5
8.5
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$300 CAD in 3 days
5.0 (512 reviews)
8.0
8.0
User Avatar
I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to design highly dynamic and automated dashboards, financial models and various other types of financial calculation tools. I have extensive experience in construction industry and will be happy to discuss in detail.
$250 CAD in 1 day
4.8 (403 reviews)
7.6
7.6
User Avatar
I have a TEAM for such work. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..
$500 CAD in 10 days
5.0 (47 reviews)
6.9
6.9
User Avatar
I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, advanced excel, VBA automation and data processing. I have successfully completed similar projects, please have a look at my portfolio for details. I have developed couple of automation tools for Ernst and Young also. You can get your work done here with highest quality at lowest price. Looking forward to work with you
$250 CAD in 3 days
4.9 (54 reviews)
6.0
6.0
User Avatar
Hi, I have worked with multiple spreadsheets creating excel modules. Let us connect and understand your requirements for various examples given for mortgage, break-even calculations.
$333 CAD in 7 days
5.0 (1 review)
2.0
2.0
User Avatar
I am currently a corporate finance analyst at a recognised financial institution in Nigeria. I develop business plans and financial models for project spanning healthcare, ICT, real estate, e-commerce and financial services. I was involved last year in a $4 billion business plan for the development of a mass housing project in Nigeria. The business plan is about 400 pages and includes business plans for 12 sub-projects. I am currently working on a real estate transaction: the client is divesting his stake to a bulk buyer. My task is to provide mortgage facility to individual off-takers while the mortgage bank provides the bulk finance. This project required mortgage calculations for each off-takers while calculating the returns on the project to us. The mortgage bank required the off-takers to pay 20% equity while structuring the repayment for 1, 3 and 5 years for off-takers. I am sure I understand your task and it's not as hard as it looks. Kindly reach out to me let's get started.
$333 CAD in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
Hi sir, I am Rahul. I have 6+ years of experience in profesional Accounting, Finance and MS Excel. I am interested to work with this project. I believe in quality work with speed. My skills as below: - Familiar with Accounting Software Xero, QuickBooks, Online QuickBooks. - Bank & Credit card Reconciliation. - Vendor Reconciliation. - Account Reconciliation. - General Ledger Report review. - EFT and payroll Report Review. - Update Payroll summary sheet and cash position Worksheet. - AJE of Sales, PR Recl, Employment Tax, Cash Payout, Accrual, Dep. & Amortization etc. - Review of Monthly & Quarter Bookkeeping. - Prepare Income statement and Balance sheet for monthly & Quater. - Work on MS-Excel. Thanks & Regards, Rahul Paneliya
$250 CAD in 3 days
5.0 (1 review)
0.3
0.3
User Avatar
Chartered Accountant having post qualification experience of more than 3 year. Highly skilled in researching issues and finding solution and best alternatives. Easy going nature and able to coordinate with all departments. Energetic, learner – always trying to learn new things & updating the knowledge.
$444 CAD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey there. I am a real estate investor myself and have previously worked as a Data Analyst for Google Nest, which gave me extensive advanced knowledge of Excel. I would like to talk to you in more detail as I want to have a crystal clear understanding of what you need this spreadsheet to do. I can get this done within 48 hours of assignment should that be the case. Preferably, we can jump on a quick Skype call so we can clarify a few particularities. I'm looking forward to hearing from you.
$300 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very proficient in Excel and would love to help. I have an MBA with an emphasis in Technology Management and have managed and worked on several project for several fortune 500 companies such as eBay, Farm Bureau, Wal-Mart (ISD Division), Overstock and Zionsbancorp.
$250 CAD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Industrial Engineer with 7 years of experience in Project Management/ Engineering for major Oil&Gas Projects. Advanced skills in Excel, VBA, Dashboards, Corporate reporting, etc. Experience in Project Cost Estimation /Project Finance / Estimate Cash Flow/ Risk Management / etc. For more details please visit my profile. Best Regards
$250 CAD in 2 days
0.0 (1 review)
0.0
0.0
User Avatar
I am an equity researcher at a bulge bracket bank with rich experience in finance modelling. This would be a perfect project for me.
$250 CAD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi there, I am an accomplished Excel user with extensive real estate financing experience, located in British Columbia, Canada. I can absolutely help you with your Real Estate Mortgage Math Problem. I have built many complex Excel spreadsheets for my own purposes when I was working for 15 years as a private real estate investor. Let me know if you're able to hop on chat or a phone call to discuss the project and budget in more detail. Cheers, Kalon
$333 CAD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I work as an Investmetn Analyst, so these kind of tasks are not new for me. If you have any questions please don't hesitate to contact me Regards Filip
$250 CAD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Burnaby, Canada
0.0
0
Member since Apr 15, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.