Create a simple excel financial model where I have the following
The product is financing.
A pool of money (dynamic field)
Product X
Product Y
Rate for product X (dynamic field)
Rate for Product Y (dynamic field)
Price for product X (dynamic field)
Price for Product Y (dynamic field)
The goal of the model is see how many units of x do I need to sell at a given rate to ensure that I have an average yearly rate for Products x and y of Z % (Z is dynamic).
If my pool of money is 50 million dollars, and if I sell 5 x units for 150K USD at 15% then I can lower my rate for product y and will still achieve a yearly yield of 12% for both x and y.
The model will tell me (You sold 5 units of X at 150K USD at 15% so you have created for yourself this amount of money to be sold at product Y for a lower rate and you will still achieve a rate of 12% yearly for your pool of money)
I need to be able to manipulate the model where I can tinker with Product Y as well by selling it at, for example, 8% which will force me to sell a certain numbers of product X to achieve a yearly return of 12% for my pool of money.
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications.
Relevant Skills and Experience
Excel, VBA
Proposed Milestones
$30 USD - m
Hello.
I have extensive experience in Excel, Coding and Data processing.I can do your project in less than a Day according to your description with full delivery and without error. I would also complete your project with the highest precision and quality.
Greetings!
I am qualified accountant with nine years of experience in accounts, financial analysis and excel modelling. Please PM me to discuss further. Thank you.
I will have this project done for you within a day. I have much experience in Finance and Microsoft Excel!
Relevant Skills and Experience
Microsoft Excel experience of 7 years along with working in it for the past two years daily for my own business.
Proposed Milestones
$55 USD - Finish