Build Excel Calculator for Children's Costs

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

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

Excel Statistical Analysis

Project ID: #11772734

About the project

29 proposals Remote project Active 7 years ago

Awarded to:

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 More

$60 AUD in 1 day
(140 Reviews)
6.5

29 freelancers are bidding on average $91 for this job

P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 AUD in 3 days
(265 Reviews)
7.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 More

$200 AUD in 3 days
(168 Reviews)
6.8
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 in 3 days
(108 Reviews)
6.5
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 More

$100 AUD in 7 days
(92 Reviews)
6.3
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 More

$66 AUD in 1 day
(132 Reviews)
5.9
abdolah2014

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

$55 AUD in 3 days
(37 Reviews)
5.3
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 in 7 days
(37 Reviews)
5.6
bassamhameed

i have experience regarding this job so kindly award me this job i will not make u disappointed so please give a try to me

$45 AUD in 2 days
(18 Reviews)
4.8
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 More

$50 AUD in 2 days
(51 Reviews)
4.8
BAVarun

Most of the reviews on my profile are for excel. I come with an experience of over 15 years in excel and contributor to various sites, where users post queries related to excel. I am efficient in creating macros an More

$100 AUD in 3 days
(36 Reviews)
4.6
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 More

$100 AUD in 3 days
(21 Reviews)
4.5
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 More

$60 AUD in 2 days
(7 Reviews)
4.4
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 More

$120 AUD in 3 days
(11 Reviews)
4.1
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 More

$50 AUD in 3 days
(8 Reviews)
3.7
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 More

$49 AUD in 3 days
(19 Reviews)
3.2
fixen2011

Hi sir, I have the same project with extracting stamp duty calculator in austrilia from website to excel. This also needs statistics and formula creation since not formula is available online. Can we discuss further More

$55 AUD in 3 days
(8 Reviews)
2.5
palrishi21

A proposal has not yet been provided

$155 AUD in 3 days
(0 Reviews)
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 More

$80 AUD in 1 day
(0 Reviews)
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 More

$133 AUD in 3 days
(0 Reviews)
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 More

$100 AUD in 1 day
(0 Reviews)
0.0