Closed

Real Estate Mortgage Math Problem - Excel Spreadsheet

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?

Skills: Accounting, Data Entry, Excel, Finance, Mathematics

See more: excel mortgage calculator with taxes and insurance, mortgage calculator, commercial mortgage calculator excel, loan amortization excel, mortgage payment calculator excel template, mortgage repayment calculator excel, excel mortgage calculator, effective interest rate amortization excel template, free real estate investment pro forma excel pdf, free real estate mortgage email list, mortgage qualification comparison excel spreadsheet, mortgage rent loan excel spreadsheet, real estate development pro forma excel, excel spreadsheet formula real estate seller net, real estate buyers list sellers list spreadsheet, real estate mortgage links, real estate development cash flow excel, real estate seller net sheet excel form, excel spreadsheet creation money, excel spreadsheet writing money

About the Employer:
( 0 reviews ) Burnaby, Canada

Project ID: #19247845

19 freelancers are bidding on average $321 for this job

schoudhary1553

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. More

$750 CAD in 10 days
(313 Reviews)
7.8
P0L

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
(289 Reviews)
7.2
axiomswb

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
(42 Reviews)
5.9
daniyal3214

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, fina More

$250 CAD in 1 day
(162 Reviews)
6.3
bhupendrayadav

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 m More

$250 CAD in 3 days
(22 Reviews)
4.2
Anjulagrawal26

Hello Alex, I am a Chartered Accountant (CPA) and Diploma in IFRS (ACCA, UK) with 10 years of experience across different industries like SCA (Essity), Serco Middle East, Deloitte and KPMG. I have expertise in C More

$300 CAD in 10 days
(8 Reviews)
3.5
darshan17755

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
(1 Review)
2.0
kcteves

Hi, I would just need a sample template so I'd be able to trace the values and understand formula. Appreciate if you can also share operational definition but based on what you've shared, it doesn't really involve v More

$250 CAD in 5 days
(2 Reviews)
0.8
ArturQQ

Expert in: ☆ VBA ☆ (Excel, access) ☆ C# ☆ SQL ☆ Google script ☆ Python Quality and problem oriented solutions guaranteed. Experienced with different kinds of databases and languages. ☆ Professional approach ☆ Attentio More

$250 CAD in 1 day
(1 Review)
0.7
Zander15

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 wan More

$300 CAD in 2 days
(0 Reviews)
0.0
caritikajain164

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 departme More

$444 CAD in 10 days
(0 Reviews)
0.0
rahulpaneliya

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 More

$250 CAD in 3 days
(0 Reviews)
0.0
leo3690

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, More

$250 CAD in 5 days
(0 Reviews)
0.0
fjanzen

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 More

$250 CAD in 2 days
(0 Reviews)
0.0
ejm819

Hi! I'll be honest with you, this is an easy excel sheet to build. I know you had to put the minimum to go forward, but even if you don't choose me, no one who knows excel should be charging you more than 60 CAD for More

$250 CAD in 3 days
(0 Reviews)
0.0
srinidhi5

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 Reviews)
0.0
LAT96

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 ser More

$333 CAD in 1 day
(0 Reviews)
0.0
kalon7

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 b More

$333 CAD in 10 days
(0 Reviews)
0.0
remodeller

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 Reviews)
0.0