Mortgage Interest Investment Calculator created in MS Excel. I want the main tab to be the entry items and the second tab to be the answers. Line A to be the question; line B to be the entry. Second Tab to be the results of the same. Line A to be the same question, Line B to be the resulting answer.
This calculator is to determine the amount each individual receives according to investment.
- ENTER amount of Loan* (ex: $100,000.00)
- ENTER loan period (ex: 1 year, 2 years, etc..) by years or (1 month, 2 months, etc..) While there is a month version, does not matter if one month or one year or five years, the monthly result will still be the same...so, I wish to enter the amount and be able to show it as either years or month. Open for discussion for this if you have any questions.
- ENTER amount of investors required (ex: ten persons, 10)
- EXAMPLE of above: $100,000.00 divided by 10 = $10,000.00 required by each investor
- ENTER the percentage of the loan (ex: 10%)
- ENTER the percentage of the manager (ex: 2%)
- PRESENT the amount of the loan monthly owed by borrower of the loan by the full percent amount (ex: 10%)
- DIVIDE accordingly to all parties percentage of ROI of the percentage of loan as above 10% (ex: 8% investors, 2% manager, or 7% investors, 3% manager) on a monthly period.
*Based on a 30 year amortized/percent only.
Hi ,
I can help you with creation of excel based calculator. I have closed more than 150 excel based projects a t various forums. We will provide following:
1. Tab 1 user can input the data
2. Tab 2 - with a click user will bale to see the results (this can be done on tab1 as well)
Regards
Sawan
Hello ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, also about me:
I am m.s of systems engineering and b.s of industrial engineering, and excel and vba expert. I have done similar projects for ROI and IRR and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, mathematics, accounting, cost calculating, project scheduling and project management and finance that helps in this project.
Hey there. What you want on Excel doesn't seem too difficult, assuming my understanding is correct. I've pretty much used Excel every day for as long as I can remember. Let me know if you're interested in helping out. Look forward to hearing from ya :)
Hello, my name is Cristian, I have a degree in Business and I work with excel every day. I have much experience with creating complex spreadsheets and formulas. Check my excel reviews. Greetings.
I am a chartered account. I have also been a Financial Analyst at an Investment Bank for 4 years. I can do this with ease and can give you a professional looking template. Working with excel and building calculators like this was my day-to-day job.
Hello I have 12 years of experience in this field. I can do your work as per requirement. I can give your job before your delay. Let's have a chat and discuss the work and counter offer.
Thank you
hi! we will offering our self for mortgage intrest investment calculation. we have both experts of ms office and also acca and MBA .
regards
SYDZ GROUP OF IT SOUTION
Hi there, I'm new to Freelancer but I have over 16 years experience with Microsoft Excel, and can put together a simple to use spreadsheet with your requirements.
Thanks!
HI ..
I am a new freelancer. I understand this is a project based on excel,
Thought I would like to suggest you a fully customerizable system to be develop if you are interested. I would like to give a try if you give me a change even free of charge, you dont want me to give me a project, if you give me the requirement I would like to see how this can be implemented. In return I will give you the working system., I would like to do some development. This is the only purpose :)
If interested drop me a message. and please dont make this as a real project, I will complete as soon as possible.
Thank you
Greetings.
I am a computer scientist and I have worked on similar projects. I would love to work on your project.
Two sheets. Two columns in each one.
Column A has the same entries in both.
Column B has original entries in sheet1 and calculated entries in sheet2. Right?