Simple excel model

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.

Kemahiran: Pemprosesan Data, Excel, Analisis Kewangan

Lihat lagi: free blank spreadsheet templates, excel spreadsheet templates for tracking, excel templates for business, excel modeling course, excel database template download, excel budget templates, excel inventory templates, excel modelling examples, import costing model excel, flash simple animal cartoons created, baggage handling model excel, equity research valuation model excel, commercial real estate valuation model excel sample, excel simple clock, vba excel simple dial, real estate development model excel, options model excel, financial model excel, banking model excel, understand evaluation model excel sheets

Tentang Majikan:
( 0 ulasan ) riyadh, Saudi Arabia

ID Projek: #14243007

8 pekerja bebas membida secara purata $59 untuk pekerjaan ini

$100 USD dalam sehari
(162 Ulasan)

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 Lagi

$55 USD dalam sehari
(44 Ulasan)

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 pro Lagi

$45 USD dalam sehari
(28 Ulasan)
$54 USD dalam sehari
(5 Ulasan)
$66 USD dalam sehari
(5 Ulasan)

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.

$70 USD dalam sehari
(8 Ulasan)

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 Lagi

$55 USD dalam sehari
(0 Ulasan)
$25 USD dalam 3 hari
(0 Ulasan)