Use Microsoft Excel and complete the following 5 questions. You must reference your cells as well as type the formulas correctly. Please follow the PV, FV, PMT, R, N, B/E format as taught in class.

Leslie Knope has no money after getting canned (fired) from her job as parks and recreation employee. She wants to have $4,000,000 in 30 years. How much would she need to steal and invest today assuming she can rob a bank and earn 10% interest compounded annually. She will not add additional payments. She wants to know the lump sum needed to invest today.