Completado

Build Excel Calculator for Children's Costs

I require a spreadsheet calculator that will be used in-house to calculate the lump sum dollars someone needs to invest today in order to be able to meet the cost of raising their children.

I have provided you with a table of costs from 2012 showing the costs at each age of the child up to age 24 depending on income bracket of the family.

The result that we are looking for is that by identifying the children and their current age the result will show the lump sum amount that the parents would need to invest today in order to be able to meet the ongoing costs of their children until age 24.

We will need the ability to enter the following information for each calculation:

Name of the child

Age of the child today

Which income sector they are in

The result will take into account the assumption that for the amount invested today it will earn 4.55% per annum over the whole period less the cost of the child for each year which will be inflated at 2.50% CPI per annum.

Please note for the budget I would like you to tell me how much it costs. So I have just entered an amount and wait to see what you can provide me with

Habilidades: Excel, Análisis estadístico

Ver más: future college costs calculator excel, macros work excel internet, macro dont work excel 2000, freelance work excel vba, excel savings calculator excel, track work excel, macros written excel 2000 work excel 2007, forex calculator excel, contract work excel access, days calculator excel, php calculator excel export, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file, forex calculator excel spreadsheet, contract work excel, online contract work excel, plastic part price calculator excel sheet, monthly savings calculator excel, cumulative gpa calculator excel, data entry work excel, forex position calculator excel, gpa calculator excel, expenses calculator excel

Información del empleador:
( 2 comentarios ) Hawthorn, Australia

Nº del proyecto: #11772734

Adjudicado a:

ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti Más

$60 AUD en 1 día
(140 comentarios)
0.0

30 freelancers están ofertando el promedio de $89 para este trabajo

rengrish

Hi , I have 10+ years of experience in Excel & VBA. Please check my past reviews and ratings. Please ping back to discuss the requirements , so that I can propose solution. I can complete this job quickly within fe Más

$66 AUD en 1 día
(132 comentarios)
0.0
Taisho

Greetings, I would prepare such professionally looking calculator in Excel sheet with VBA macros. It would include a list to select income sector, validation for age etc. There would be also a sheet with table fr Más

$50 AUD en 2 días
(50 comentarios)
0.0
arranmercer

Hello Mate, I am a certified Microsoft Office specialist who works as a data analyst. I have created a similar project for a client on freelancer, who wanted a spreadsheet which calculated yearly earnings over an am Más

$120 AUD en 3 días
(11 comentarios)
0.0
cemerel

Hello, I have extensive experience with MS Excel including VBA coding and of course high grade formula writing. I will be able to complete this work within minimum amount of time and provide you with a smart looking i Más

$100 AUD en 1 día
(0 comentarios)
0.0
katilinas

Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!

$70 AUD en 3 días
(108 comentarios)
0.0
$30 AUD en 1 día
(2 comentarios)
0.0
statAnalysis

Looking forward to support you with this project. best regards, Joerg. PS: You can add me on skype, if you have any questions: [login to view URL]@skype.

$149 AUD en 3 días
(2 comentarios)
0.0
serdaryalcin

Hello, I work in insurance and pension sector. So I think there is a flaw in your estimations. You must make the estimations taking the inflation as 0. And the result should show the lump sum as today's values. I Más

$100 AUD en 3 días
(21 comentarios)
0.0
ACMAuk

I am MSc Statistics and Chartered Management Accountant from Chartered Institute Of Management Accountants UK, having 6 years of experience of financial modeling etc. We help you with a highly professional financial Más

$200 AUD en 3 días
(168 comentarios)
0.0
UsmanNasar87

Hello, I have very good knowledge of MS Excel such as formulas (sumifs, vlookup, and, average, concatenate, countifs, iserror, match, min, max, mid, left, offset and many more), charts, data analysis, calculation, diff Más

$49 AUD en 3 días
(19 comentarios)
0.0
kmande

Hello!! I am MBA Finance graduate with an excellent command over Excel Application and Financial [login to view URL] task you described is clear and straightforward. I don't see any problem in delivering it withi Más

$50 AUD en 0 días
(10 comentarios)
0.0
RRconsultant

Hi there, I am an excel and financial specialist and can help you with the calculator. Look forward to hear back from you. Thanks, RRC

$300 AUD en 7 días
(37 comentarios)
0.0
Guruchandar

I have gone through your job posting and become very much interested to work with you. I am an expert in these fields . I have already completed projects like this. I have excellent command over English. I am a hard wo Más

$50 AUD en 3 días
(8 comentarios)
0.0
shikhamehta

Hey, I am an expert in Excel and have built several calculators for my clients and have been highly appreciated for the quality work I do. I reviewed the requirements description you shared and also saw the image Más

$100 AUD en 7 días
(92 comentarios)
0.0
$150 AUD en 3 días
(0 comentarios)
0.0
abdolah2014

hello I am an excel-vba Expert and I can finish your project so fast pm me to discuss more ...............................................................................

$55 AUD en 3 días
(37 comentarios)
0.0
JonBrogan16

I have taken many courses in Excel through my previous companies as well as college and know how to handle any calculation that is needed. In my current role, I provide many reports in Excel using a variety of calculat Más

$133 AUD en 3 días
(0 comentarios)
0.0
SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA. Any code I provide is well structured and commented, client gets whole access and rights for th Más

$60 AUD en 2 días
(7 comentarios)
0.0
$30 AUD en 2 días
(0 comentarios)
0.0
wsfuhrman

Hello, My name is William Fuhrman. I'm currently studying Business Management and Computer Science at Michigan State University. I have a vast amount of knowledge in Excel and would love to help you out with your proj Más

$80 AUD en 1 día
(0 comentarios)
0.0