Develop a spreadsheet model of fundraising campaign

Assignment Help Finance Basics
Reference no: EM131439181

Question: The director of a nonprofit ballet company in a medium-sized U.S. city is planning its next fundraising campaign. In recent years, the program has found the following percentages of donors and gift levels:

                                                                          Average Number

     Gift Level                            Amount                     of Gifts

     Benefactor                            $10,000                         3

     Philanthropist                        $5,000                           10

     Producer's Circle                   $1,000                           25

     Director's Circle                    $500                              50

     Principal                               $100                     7% of solicitations

     Soloist                                  $50                      12% of solicitations

Develop a spreadsheet model to calculate the total amount donated based on this information if the number of the company contacts 1000 potential donors to donate at the $100 level or below.

Reference no: EM131439181

Questions Cloud

Explain the effects of plagiarism extend beyond the walls : Grand Canyon University takes plagiarism seriously; however, the effects of plagiarism extend beyond the walls of the University. How can plagiarism affect your professional career beyond your doctoral pursuit at GCU?
What is the deadweight loss associated with monopoly : A monopolist faces a demand curve given by: P = 210 - 5Q, where P is the price of the good and Q is the quantity demanded. The marginal cost of production is constant and is equal to $60. There are no fixed costs of production. What is the deadwei..
What types of client problems are best suited for therapy : What types of client problems are best suited for experiential family therapy compared to structural family therapy? Explain.
Omnibus budget reconciliation act : The Omnibus Budget Reconciliation Act (OBRA) limits physician payments. In your opinion, is the physician salary still too high in the U.S. now?
Develop a spreadsheet model of fundraising campaign : Develop a spreadsheet model to calculate the total amount donated based on this information if the number of the company contacts 1000 potential donors to donate at the $100 level or below.
Choose a real or made up example of a company : 1. Choose a real or made up example of a company, and describe at least three variable costs the company has. 2. Choose a real or made up example of a company, and describe at least three fixed costs the company has.
Would you consider any of the paragraphs to be plagiarized : Given the information provided, would you consider any of the paragraphs to be plagiarized? Why? If there is plagiarism evident based on the report, how would you change the submitted document to eliminate the plagiarism and why?
Is the concept of the enmeshed mother and disengaged father : Is the concept of the enmeshed mother and disengaged father, and the typical structural family therapy response to it, sexist?
Can an attorney satisfy these requirements : Can an attorney satisfy these requirements and be an ethical person who applies good moral judgment? Why or why not? How can the justice system ensure ethical standards are followed

Reviews

Write a Review

Finance Basics Questions & Answers

  What is mercury''s financial breakeven point

Mercury Air's debt consists of $50,000 in accounts payable, $100,000 in 10 percent notes payable, and $240,000 in 8 percent bonds. Mercury has no preferred stock. If its marginal tax rate is 35 percent, what is Mercury's financial breakeven point?

  Develop an amortization schedule

There are seven years remaining on a ten year car loan. The interest rate is 10.25%. The monthly payments are $450.00. The credit union is willing to accept the present value of the loan as a pay off.

  What cash flows will you receive

Assume that as it is may 15, 2015, and the government of Canada has just issued bonds with a may 2020 maturity, $1000 par value, and a 5% coupon rate with semi-annual coupons. The first coupon payment will be paid on November 15, 2015.

  What is their yield to maturity

Ezzell Enterprises' noncallable bonds currently sell for $1,165. They have a 15-year maturity, an annual coupon of $95, and a par value of $1,000.

  Use the approxiimate yield formula or a handheld financial

Use the approxiimate yield formula or a handheld financial calculator to find the rate of return on this load fund; it was purchased a year ago, and its dividends and capital gains distributions over the year totaled $1.05 a share. (Hint: As an in..

  What is the value of the stock

A stock just paid a dividend of $3.0, and dividends will increase by 2.0% every year. Its required rate of return is 18.0%. What is the value of the stock?

  Which is a better machine based on eac

There are two machines with the following cash flow. Which is a better machine based on EAC.Consider the interest to be 6%. Machine/Year Y0 Y1 Y2 Y3 A 15 5 5 5 B 10 6 6

  Computing time value of money problems

(Monthly compounding) If you bought a $1,000 face value CD which matured in nine months, and which was advertised as paying 9% annual interest, compounded monthly, how much would you receive if you cashed in your CD at maturity?

  Value per share of merged firm

Firm A is planning on merging with Firm B. Firm A will pay Firm B's stockholders the current value of their stock in shares of Firm A. Firm A currently has 2,300 shares of stock outstanding at a market price of $20 a share.

  What would be the present value of marys deferred annuity

The board assumes the bonus should stay the same, but Mary knows the present value of her bonus will change. What would be the present value of Mary's deferred annuity?

  Lower-risk or higher-risk insurance pools

Include in your policy the importance of identifying the likely risk associated with each customer and categorizing your customers into lower-risk or higher-risk insurance pools. Besides safe driving, what other factors contribute to this less ris..

  Present value-interest and time value of money

What single payment could be made at beginning of first year to achieve this objective? What amount could you pay at the end of each year annually for 10 years to achieve this same objective.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd