I need someone to create an excel template that can calculate future values of all my individual financial products. The template will have cells for me to key in all relevant parameters depending on the product type. e.g. current value, number of periods, interest rates, floating / fixed rates, maturity value, net asset value, monthly payment, compounding period, inflation rate, etc. I can then add up all these 10 assets/ liabilities and calculate their combined present and future value over the next 30 years.
For each product, I will need to have 30 data points of networth. I will then plot all the products in a chart so see my networth over time.
You would need to be very familiar with all the 10 products and the types of parameters that will affect their future value as every product should have specific parameters. E.g. Mortgage loan should have "n" months for loan period, “x” interest rate, “y” loan amount. Life insurance (regular premium) does not have an upfront investment, there is “n” maturity date, “x” returns, etc. I am not an expert in all these products, hence need you to define all parameters and build the calculators.
The 10 products are: 1) Time deposit 2) Life insurance 3) Investment linked insurance 4) Mortgage loan 5) Bonds 6) Unit trust 7) Monthly savings plan 8) Foreign currency investment 9) Critical illness insurance plan 10) Stocks / equities
Some products like stocks, foreign currency, investment linked insurance may be a tricky as the returns/losses depend on the market conditions, hence I am not quite sure how to project networth. Say if I have a total of $50,000 in stocks today, how much will my stocks be worth next year?
Regards Ryan
I am an ACCA , APA and Mcom finance
having full command over advance excel
Your project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern...
I am fully competent in doing said assignment/job,
I have more than 7 years of exp
hire me at fordable cost with best results, readily available for said task........
regards
javed
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
HI,
I'll send you the excel based calculator for all 10 products.
You will get dashboard at the front page to see input-output
I am specific provider for finance analytic
thanks,
raiseq
Dear Sir,
Being a Chartered Accountant and an excel experts I am ready to provide you perfect financial calculators.
Consider my bid for faster & quality work
Thanking you for going through
Please PM me if interested
I am well versed with excel and can complte any project which requires the use of Excel. Wheras the calculation of future values of fiexd deposits will be simple, the calculation of future values of foreign currencies and stocks will indeed present a problem. I propose to calculate these on the basis of performances of the last thirty years. Hoever, stocks, are largely "short term investments", because with the advent of newer technologies,the older companies tend to fiizle away, unless ofcourse if they keep pace with technology. I think, I am veering off the project
Hi, I would like to offer my services for preparation of excel model.
I shall try to create same type of input parameters for all the categories. However results will be comparable. Regarding stock future market value projections and dividend receipts will be used as input parameter to obtain the net worth results.
I am professionally qualified management accountant (ACMA) with more than seven years of experience.
Please feel free to discuss details. Just leave me a message so that we can discuss further.
Regards.
Zafar
Hi
I have big experience with Excel and mathematics, so you can hire me.
I always do my job fast and neatly.
My Skype - avkiev. Feel free to contact me.
Best regards
Alex
Congratulations, the products you have chosen are indeed the required set in a complete financial portfolio. I will deliver tested modules and not reuse web material, ensuring the best case investment scenarios are highlighted in the excel. I can provide work in process every day and likely complete the work early except that I would like to ensure they work for all cases. These are:
1) Time deposit
2) Life insurance
3) Investment linked insurance
4) Mortgage loan
5) Bonds 6) Unit trust 7) Monthly savings plan
8) Foreign currency investment
9) Critical illness insurance plan
10) Stocks / equities (in portfolio as highlighted in proposal request)
I provide professional writing and quantification services. I can input wroies as well or otherwise improve your selection of excel tools across all subjects for your regular assignments and more detailed research based industry work.
My writes appear regularly on the India Morning Report and It's Monday Again!(US Markets), Finance and information series. The blogs have been appreciated for series on ebooks, IPL, Superbowl, Twitter and I stay updated on current affairs Language and tone are tools with a range from stylised formal to beckoning informal or blunt casual modes flexibly and do not reflect strains of limitations and deadlines.
I am also available for more such projects down the line once you like my style as your own.
I can provide you specific samples and references when we engage with each other
I am competent and confident in handling such kinds of assignments specially related TVM and Corporate finance. I am a Financial Analyst by profession and managing diversified portfolios of a significant proportion of corporate sector