Build Excel Calculator for Children's Costs

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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 Статистичний аналіз

ID Проекту: #11772734

Про проект

29 заявок(-ки) Дистанційний проект Остання активність 7 роки(ів) тому

Доручено:

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 Більше

$60 AUD за 1 день
(140 відгуків(-и))
6.5

29 фрілансерів(-и) готові виконати цю роботу у середньому за $91

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 за 3 дні(-в)
(265 відгуків(и))
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 Більше

$200 AUD за 3 дні(-в)
(168 відгуків(и))
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 за 3 дні(-в)
(108 відгуків(и))
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 Більше

$100 AUD за 7 дні(-в)
(92 відгуків(и))
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 Більше

$66 AUD за 1 день
(132 відгуків(и))
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 за 3 дні(-в)
(37 відгуків(и))
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 за 7 дні(-в)
(37 відгуків(и))
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 за 2 дні(-в)
(18 відгуків(и))
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 Більше

$50 AUD за 2 дні(-в)
(51 відгуків(и))
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 Більше

$100 AUD за 3 дні(-в)
(36 відгуків(и))
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 Більше

$100 AUD за 3 дні(-в)
(21 відгуків(и))
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 Більше

$60 AUD за 2 дні(-в)
(7 відгуків(и))
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 Більше

$120 AUD за 3 дні(-в)
(11 відгуків(и))
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 Більше

$50 AUD за 3 дні(-в)
(8 відгуків(и))
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 Більше

$49 AUD за 3 дні(-в)
(19 відгуків(и))
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 Більше

$55 AUD за 3 дні(-в)
(8 відгуків(и))
2.5
palrishi21

A proposal has not yet been provided

$155 AUD за 3 дні(-в)
(0 відгуків(и))
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 Більше

$80 AUD за 1 день
(0 відгуків(и))
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 Більше

$133 AUD за 3 дні(-в)
(0 відгуків(и))
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 Більше

$100 AUD за 1 день
(0 відгуків(и))
0.0