Need help with excel spreadsheets
- or -
Post a project like this2852
$100
- Posted:
- Proposals: 5
- Remote
- #1185604
- PRE-FUNDED
- Completed
Description
Experience Level: Intermediate
I have the income and expenses of about 50 properties in the first tab of the spreadsheet. The 2nd tab has an amortization schedule which allows for extra payments. Before I invest any more time setting things up, I wanted an expert to look at the direction I'm going in and tell me if there is a better way to set it up where each of the properties can have it's own amortization schedule with input fields.
On an as needed basis we will need someone to answer questions and help develop this into something much more including a global annual cash flow over the next 10 years
-as properties amortize down
-as some properties are sold to help pay off the loans on the other properties with smallest balances
-to see the impact of higher rent that results in extra payments but a slightly higher mortgage
We can already modify certain input fields to see the effect that extra monthly payments has on the principal balance after a desired number of years but getting this done for 50 properties is the challenge.
On an as needed basis we will need someone to answer questions and help develop this into something much more including a global annual cash flow over the next 10 years
-as properties amortize down
-as some properties are sold to help pay off the loans on the other properties with smallest balances
-to see the impact of higher rent that results in extra payments but a slightly higher mortgage
We can already modify certain input fields to see the effect that extra monthly payments has on the principal balance after a desired number of years but getting this done for 50 properties is the challenge.
Dave S.
100% (3)Projects Completed
3
Freelancers worked with
3
Projects awarded
18%
Last project
18 Jun 2019
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies