Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

could you help me to fill out this excel by the following question? Operating Budget Information for International Nonprofit Organization Project Please review the given

could you help me to fill out this excel by the following question?

image text in transcribed Operating Budget Information for International Nonprofit Organization Project Please review the given information for an Operating Budget for International Nonprofit Organization Given: All Salaries and Benefits costs involving inflation increased 10% for the Year 2. Please use the Excel template to complete the problem. You may amend the worksheet to complete the project. As a project or program manager, you are focused on cost, schedule, and performance. What is final Operating Budget for Year 1 and Year 2? Year 1 and Year 2 Revenue Corporate Donations $ 40,000.00 Fundraising $ 20,000.00 Individual Contributions $ 10,000.00 Interest $ 40.00 Program Fees $ 30,000.00 Grants $ 350,000.00 Year 1 Expenses Admin. Supplies and Services $ 10,000.00 Building Expenses Insurance $ 2,000.00 Miscellaneous $ 3,000.00 Utilities $ 4,500.00 Loan Payments $ 1 6,000.00 Equipment $ 5,000.00 Insurance $ 1 3,000.00 Legal Fees $ 5 00.00 Marketing $ 1 0,000.00 Phone Services $ 3,500.00 Postage $ 2,000.00 Salaries and Benefits Administrative $ 15,000.00 Benefits $ 10,000.00 Executive Director $ 100,000.00 Developmental Director $ 75,000.00 FICA & Taxes $ 2 0,000.00 Health Insurance $ 8,000.00 Signs $ 1,000.00 TShirts $ 1 0,000.00 Travel & Conference $ 2,000.00 OPERATING BUDGET Year 1 I. II. Year 2 ESTIMATED INCOME A. I. TOTAL $0.00 $0.00 II. A. TOTAL $0.00 $0.00 II. B. TOTAL $0.00 $0.00 ESTIMATED EXPENDITURES A. B. MISCELLANEOUS C. ACTIVITIES 1. OPERATIONAL EXPENSES III. Subtotal Estimated Expenditures IV. Total Estimated Income Income less Expenses Excess or Deficit for the Year #VALUE! #VALUE! #VALUE! #VALUE! Page 1 of 2 #VALUE! #VALUE! $0.00 #VALUE! #VALUE! $ - #VALUE! 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microeconomics: An Intuitive Approach With Calculus

Authors: Thomas Nechyba

2nd Edition

1305650468, 978-1305650466

More Books

Students also viewed these Finance questions

Question

Find the median for the set of measurements 2, 9, 11, 5, 6.

Answered: 1 week ago

Question

An action plan is prepared.

Answered: 1 week ago