a. Prepare the first and second page of the 3-page assignment. Each page will show a spreadsheet, each with data shown in different ways.

On the spreadsheet for the first page, show your work area (including your notes) and all your data (with the dollar amounts).

On the spreadsheet for the second page, show all your formulas. (Remember that the entire spreadsheet will only be formulas.) You can make these formulas visible by pressing the Ctrl key and the Tilde key (~) at the same time. The Tilde key is located to the left of the number 1 on the keyboard.

a. Prepare the third page of the 3-page assignment. This page will show two line charts, both showing a chart title and labels for the X and Y axes. Format the charts, so they are easily readable and understandable.

On the first chart, show a comparison of the projected total income per month from April through September 2014. (Do not show itemized income.) Title this Comparison of Monthly Income. Show the name of the months on the X axis.

On the second chart, show a comparison of the projected total expenses per month from April through September 2014. (Do not show itemized expenses.) Title this Comparison of Monthly Expenses. Again, show the names of the months on the X axis.

Projected Income from April through September 2014:

You will receive the following:

$50,000/year for foundations, which will be evenly distributed as monthly income throughout the year

$600/month from individual donations

$300/month from additional donations that will start June, 2014

$6,000 from a 6-month grant will be received in July, 2014. The money will be counted as income in full in August.

A 25% increase from last year's banks sponsorship. (Last year, the sponsorship amount was $10,000.) The funds were donated in June but will be recorded in full in the month of July.

25% increase of the amount of funds raised from last year fundraising event. (Last year, $35,000 was raised.) Even though the fundraising event will be held in August, the funds will be recorded in full in the month of September.

Money from your partners inheritance. The money is currently invested in a mutual fund which is gaining interest every year. When it reaches a total amount of $15,000 (predicted for July, 2014), you plan to invest the total amount in your business account at that time.

Projected Expenses from April through September 2014:

On a monthly basis, you plan to continue to spend the following:

$800 for renting office space

5% of monthly income for office supplies for all months except July, August and September

$250 for training and development

$400 for insurance

$125 for student meals

In July, you plan to hire a consultant to help the Board develop leadership skills; the cost will be $3000. This cost will be evenly distributed every month from July through September.

In April and May, you plan to hold a retreat for Board development and spend $500 to rent a facility for each event.

In August, you plan to spend $8,000 to hold a fundraising event.

In June, you plan to decrease the Board's training and development expenditures by 25% as the need for ongoing formal training will decrease. This June expense will then apply and be the same amount through September.

In June, you plan to increase the expenses for student meals by 6% as it is predicted that there will be an increase in the cost of food. This June expense will then apply and be the same amount through September.

In September, you plan to spend $450 to conduct a Volunteer Recognition event.

======================================================

PLEASE HELP ME!

PLEASE SHOW THE FORMULA AND YOUR WORK! THANKS IN ADVANCE!

Financial Forecastfor Healthy Hearts 2 Developed by: Date: 3 Healthy Hearts will/will not have the funds to hire a Program Manager in Q4,2014. 4 Starting Balance 3 Income Projections Foundations 6 Individual Donations 7 Additional Donations 8 6-month Grant 9 Bank Sponsorship Fundraising Event 11 Inheritance 12 Expense Projections Office Space 13 Office Supplies 14 T.rng and Development 15 Insurance 16 Student Meals 17 Consultant 18 Retreat Facility 19 Fundraising Event 20 VolunteerRecognition Event 21 April- 14 May- 14 Jun- 14 Continued 22 Income Foundations 23 Individual Donations 24 Additional Donations 25 6-monthGrant 26 BankSponsorship 27 Fundraising Event 28 Inheritance 29 Total Income 30 31 Expenses Office Space 32 Office Supplies 33 T.rng and Development 34 Insurance 35 Student Meals 36 Consultant 37 Retreat Facility 38 Fundraising Event 39 Volunteer Recognition Event 40 Total Expenses Financial Forecastfor Healthy Hearts 2 Developed by: Date: 3 Healthy Hearts will/will not have the funds to hire a Program Manager in Q4,2014. 4 Starting Balance 3 Income Projections Foundations 6 Individual Donations 7 Additional Donations 8 6-month Grant 9 Bank Sponsorship Fundraising Event 11 Inheritance 12 Expense Projections Office Space 13 Office Supplies 14 T.rng and Development 15 Insurance 16 Student Meals 17 Consultant 18 Retreat Facility 19 Fundraising Event 20 VolunteerRecognition Event 21 April- 14 May- 14 Jun- 14 Continued 22 Income Foundations 23 Individual Donations 24 Additional Donations 25 6-monthGrant 26 BankSponsorship 27 Fundraising Event 28 Inheritance 29 Total Income 30 31 Expenses Office Space 32 Office Supplies 33 T.rng and Development 34 Insurance 35 Student Meals 36 Consultant 37 Retreat Facility 38 Fundraising Event 39 Volunteer Recognition Event 40 Total Expenses