I have an excel assignment and wanted to see if someone could help me with it.

Complete the tasks contained on the following worksheets. Name your workbook: Last Name Excel assignment Submit the assignment (excel workbook) through Blackboard. Due: Wednesday, August 30 at 11:59 p.m. Select your name from the list SELECT YOUR NAME FROM THE D Entering your name will impact v T YOUR NAME FROM THE DROP-DOWN LIST ng your name will impact values on the remainder of the exam Mary Funck a0c0e52a34474fb7ac1d74df22495439923b5685.xlsx #1 =$D$6 =A$4 =$F4 =B$4 =F2 =H3 Example Assume you are working with the spreadsheet shown above. For each the formulas shown above, show what the result of copying the formula to the designated destination ce For example, what formula would be in cell C2 if you copied the formula in cell B5 (=A$4) to cell C2? Please use the column and row headers and labels as shown. Include the $ symbol where appropriate I have provided an example of copying the formula in cell E9 to cell G10 password sibs + # Mary Funck signated destination cell. ppropriate password sibs + # a0c0e52a34474fb7ac1d74df22495439923b5685.xlsx #1 Use the following data to complete the tasks specified below: 4 5 6 7 Enter a FORMULA to solve for 5 x (6 + 7)4 Enter a FORMULA to solve for (5 + 7 x 6)4 - 8 Enter a FORMULA to solve for ((5 + 4) x 6)(7/8) Enter a FUNCTION to sum the values listed in row 2 Enter a FUNCTION to average the values listed in row 2 ** Use cell references in formulas, do NOT hard code the numeric values 8 Complete the following tuition schedule: Credits Tuition Schedule Credit Charge This schedule shows how tuition charge change as the number of hours and the charge per credit hour changes. The credit hours should range from 3 to 18 in increments of 3. (A6:A11) The credit charge per class should range from $100 to $325 in increments of $75 (B5:E5) #N/A Tuition charge is calculated in cells B6:E11. The tuition schedule (A5:E11) should be completed using only references to assumptions area and formulas/function. Do no Remember to use relative, mixed, or absolute cell references depending on how the reference will change when the formula For example, if you enrolled in 3 credits and each credit cost $100, then the tuition charge equals 3 x 100 = $300 + (300 x % surcharge) Assumptions Starting Number of Credits Starting Charge per credit hour Credit Hours Increments Credit Charge Increments Surcharge 3 $100 3 $75 and the charge per credit hour changes. ments of $75 (B5:E5) ces to assumptions area and formulas/function. Do not hard code data. ng on how the reference will change when the formula is copied. 4a) Use financial math functions or formulas to complete the following problems: A #N/A B #N/A C #N/A You need your retirement income for 30 years and you expect to earn How much will we need at retirement to provide adequate funding? D Continuing this retirement scenario, let's assume that you will retire 20 yea How much do we need to invest each year so that we accumulate the de A FV N PMT I/Y PV = 4b) Complete the shaded cells for each of the following problems concerning uneven cash flow s #N/A #N/A Year 0 1 2 3 4 5 Sum of PVs Net Present Value Future Value IRR Cash Flow 1,000 3,500 2,500 2,100 1,270 Should equal #N/A Future Value Annual Rate PV of Cash Flow 3,575 5.15% Years Frequency Annual Semiannual Quarterly Monthly Weekly Daily Periods/Year 1 2 4 12 52 365 PV (Formula) PV (Function) ng problems: ears and you expect to earn 5% per year during retirement. rovide adequate funding? me that you will retire 20 years from now and you expect to earn 6% per year prior to retirement. o that we accumulate the desired amount by retirement (found in part C)? During Retirement C B FV PV N PMT I/Y = ncerning uneven cash flow streams: Rate of Return Should equal FV N PMT I/Y PV = Before Retirem D FV PV N I/Y PMT = tirement. Before Retirement D