Using the CPI calculator located here: https://www.bls.gov/data/inflation calculator.htm, determine the following: Produce a 2023-US-Dollar Equivalent monthly...

 

Transcribed Image Text:

Using the CPI calculator located here: https://www.bls.gov/data/inflation calculator.htm, determine the following: Produce a 2023-US-Dollar Equivalent monthly budget for Scott in Microsoft Excel. Create a pie graph representing the proportionate allocation of Scott's budget. Regardless of what number you calculated for Scott's 2023-equivalent rent payment, assume $12,000/month. Given this, what annual interest rate is needed to get from their $300/mo. in 1923 to $12,000/mo. in 2023? What would Scott's annual after-taxes income have to be in 2023 dollars to support this lifestyle? (Assume $12,000/month for rent, but all other expense items are as you calculated them using CPI adjustment.) If you could offer only one piece of advice to Ol' Scott, what would it be? Monthly Budget for the Fitzgerald Family, 1923 Monthly ExpeNDITURE 1923 TAXES 200.00 TRIPS, PLEASURE + PARTIES RENT 300.00 FOOD---- 200 00 House LIQUON 8000 COAL WOOD 35 co PLAZA 2650 Ice- 8 50 ALABAMA 3300 GAS - 2700 ATLANTIC CITY 1000 LIGHT- 14 50 THEATRE PHONE 25 00 BARBER 10 00 WATER- 500 HAIR DRESSING 15100 CHARITY 400 SERVANTS-295.00 WILD PARTIES 10000 Taxis 1500 DOCTORS--- 42 50 Gambling 33/00 DRUG STORE-- 32 50 LUNCHES (NY) 2500 CLUB--- SUBWAY (cc) 2100 105 50 Miscelaneous Cash 27600 NEWSPAPERS- 5c0 BOOKS---- 1150 FLOWERS---- 900 RUTO 2300 PLUMBER 13 50 ELECTRIC- 150 COMUT RITION 400 SCOTT'S CLOTHES 33 00 Zelda's CLOTHES 10000 DRoy's CLOS 2.5 OC HOUSE HOLD 8100 RN) MISSCLUS CHARGES TYPING- 12/00 1620 40 785 60 1620.40 2396.00 from F. Scott Fitzgerald's private papers Yes, this is own handwriting (cool, no?) Using the CPI calculator located here: https://www.bls.gov/data/inflation calculator.htm, determine the following: Produce a 2023-US-Dollar Equivalent monthly budget for Scott in Microsoft Excel. Create a pie graph representing the proportionate allocation of Scott's budget. Regardless of what number you calculated for Scott's 2023-equivalent rent payment, assume $12,000/month. Given this, what annual interest rate is needed to get from their $300/mo. in 1923 to $12,000/mo. in 2023? What would Scott's annual after-taxes income have to be in 2023 dollars to support this lifestyle? (Assume $12,000/month for rent, but all other expense items are as you calculated them using CPI adjustment.) If you could offer only one piece of advice to Ol' Scott, what would it be? Monthly Budget for the Fitzgerald Family, 1923 Monthly ExpeNDITURE 1923 TAXES 200.00 TRIPS, PLEASURE + PARTIES RENT 300.00 FOOD---- 200 00 House LIQUON 8000 COAL WOOD 35 co PLAZA 2650 Ice- 8 50 ALABAMA 3300 GAS - 2700 ATLANTIC CITY 1000 LIGHT- 14 50 THEATRE PHONE 25 00 BARBER 10 00 WATER- 500 HAIR DRESSING 15100 CHARITY 400 SERVANTS-295.00 WILD PARTIES 10000 Taxis 1500 DOCTORS--- 42 50 Gambling 33/00 DRUG STORE-- 32 50 LUNCHES (NY) 2500 CLUB--- SUBWAY (cc) 2100 105 50 Miscelaneous Cash 27600 NEWSPAPERS- 5c0 BOOKS---- 1150 FLOWERS---- 900 RUTO 2300 PLUMBER 13 50 ELECTRIC- 150 COMUT RITION 400 SCOTT'S CLOTHES 33 00 Zelda's CLOTHES 10000 DRoy's CLOS 2.5 OC HOUSE HOLD 8100 RN) MISSCLUS CHARGES TYPING- 12/00 1620 40 785 60 1620.40 2396.00 from F. Scott Fitzgerald's private papers Yes, this is own handwriting (cool, no?)