I need help with the information/formulas for the cells. I am including screen shots. How do I format the information in 3C on pic Lost1? Also, how to I set cell G38 to show as (0, b) (pic Lost 1)? On the next sheet (funding) I am supposed to bring my information forward. How do I invest a -383%? All the APR's are prefilled, with what seem like crazy numbers. I need to use this data to complete the project, due tonight. Can you please help with the data entry formulas?

B C D E G H J K M must be greater than one. Format all coats as Currency with 2 decimal places. To start, Budget Category Subtotal ercentage of Total 10 modify the cost of your time as appropriate. Personnel Costs $16,000.00 4.45% 11 Administrative Costs $3,660.00 1.02% 12 Outreach Costs $85.00 0.02% 13 Project Budget Program Costs $340,000.00) 34.51% 14 Personnel Costs Budget Total 1353,745.00 15 Budget Item Total Cost 16 Cost of your time [30 hours) 12 $1,000.00 $12,000.00 Budget Cost Projection 17 Application Creator/Info Organ $2,000.00 $4,000.00 3 a Below, you will generate a 5 year projected cost for your budget, starting with your budget total. You will base your projection on CPI 19 values that you look up. Use this procedure to look up the CPI value: 20 Subtotal: $16,000.00 21 Administrative Costs 1. Go to Bureau of Labor Statistics page link https://data.bis.gow/cgi-bin/surveymost?cu 2. Check the box to the left of text "U.5. city average, All items - CUURDODOSAD" (CPI Values) 22 budget Item Quantity Cost Per Total Cost 23 Electronics [ Computers, Printer 4 $500.00 $2,000.00 3. Press the "Retrieve Data" button at the bottom of the list. This should take you to a CPI table for about the last 10 years. 24 Office Supplies [Paper, Pens,... 50 $25.00 1,250.00 First, fill in the CPI value for the given month and year. Then, fill in the CPI values for the next 6 years, advancing exactly one year for each 25 PhoneiInternet 4 $65.00 $260.00 value. For example, if you start in February 2011, your next CPI value will come from February 2012. Format your CPI values as Numbers Cooperation feel Access to Loy $150.00 $150.00 with 3 decimals of precision. 27 Subtotal: $3,660.00 28 Outreach Costs Tear Number CPI Value Month Year 29 Budget Item Quantity Cost Per Total Cost 8 Fundraising [ Hours) 25 $1.00 $25.00 1 237.852 2014 30 236.306 8 2015 31 Advertising 5000 $0.01 $60.00 240.843 8 2016 32 245.513 8 2017 252.146 2018 34 Subtotal: $85.00 256.558 2019 35 Program Costs 36 Budget Item Quantity Cost Per Total Cost 3b Now, from the year number and CPI values, find the slope and y intercept of the best-fit line for your 4G LTE Modem + 6 Mos Cover 2000 $170.00 $340,000.00 Slope[O) 3.392 Y-Intercept [0. b] 231.23 34 3 C Finally, project the CPI forward an additional 5 years using your slope and intercept; calculate the 5 year inflation rate from 41 Subtotal: $340,000.00 your year 6 CPI value and the calculated value; and apply the inflation rate to your budget total to find a 5 year budget projection. The Year Number to use for your further 5- 11 The projected CPI value for that year The 5-year inflation rate based on the last 45 CPI value in the table and the projected or Budget Total [brought forward from abo Tour S-year Budget Total ProjectionA B C D E F G Your name (brought forward from the Monthly Budget sheet): Jana Hackamack-Klingman W N 4 On this sheet, you will consider how to cover the projected cost of your Project Budget. In particular, you will calculate the 5-year balance for a percentage of your projected cost assumed to be invested at a given interest rate with annual compounding; the 5-year balance for a given monthly donation amount invested at a second interest rate; and a monthly loan payment required for a 5-year loan to cover the remainder of your 5-year projected cost, using a third interest rate. 7 Start by looking up rates to use as APRs in the following historical table of 30-year fixed mortgage rates: 8 9 http://www.freddiemac.com/pmms/pmms30.html 10 11 12 (Mortgage Rates) 13 14 Enter these items as percentages or decimals; for example, a value of 4.03 in the table would be entered here as 4.03% or 0.0403. Also format each rate as a Percentage with 2 decimal 15 16 APR Year 2010 1974 1988 17 APR Month 10 4 7 18 4.13 8.58 10.43 19 20 21 5 Now, perform each of the calculations indicated. Recall that the loan payment formula for the amount PMT that must be paid n times per year for t years to pay off an 22 initial principal amount P, assuming interest accrual at a rate of r, is given by 23 24 PMT = P*(r)/[1 - (1 + r)*(-n't)) 25 26 Format all amounts as Currency with the $ symbol and 2 decimal places. 27 Excel Grading Sheet |Project Budget and Projection Funding +132 X V A B C E 25 26 Format all amounts as Currency with the $ symbol and 2 decimal places. 27 Bring your 5-year projected budget total forward from the Project Budget and Projection 29 6 Sponsorship (invest a fixed amount for 5 years with 8 Loan payment (determine the monthly payment required for a 5-year loan to cover the remainder of the 30 annual compounding) budget costs 31 itage of your Budget Total to -383.0% The additional amount you need to cover your 5-near Principal amount to invest (P). based on your budget Your APR (] 1043.0% 32 total and the percentage in Your APR (0) 413.0% Number of payments per year [n) i ber of compoundings per gear Number of rears [t 35 Number of hears [t The monthly loan payment 36 Your 5-near sponsorship total 37 38 7 Fundraising (invest monthly donations for 5 years Legend with monthly compounding) Monthly contribution $0.00 If a cell is shaded You should 40 amount [PMT] 859.0% Blue Enter a text response 41 Your APR[0) Number of compoundings Green Enter a number 42 per gear [O) 43 Number of gears [() Gold i Excel formula Your 5-gear fundraising total [Hint: use the future value Any other color Make no changes 44 of periodic pauments" Excel Grading Sheet Project Budget and Projection Funding +