Question

Question2: Create a table that shows 25% increase in revenue every month from January to May when January revenue is $1000. Follow the steps in the video to create the formula for calculation. Save the file. Question3: What will your pension be when you retire? Per data given below. Watch the video to create the formula. Save the file and upload to blackboard. Pension Data: PMT $2000 Start rate 10% increment 2% Start years 10 Increment 5 yrs

Answer 1

Q1

Revenue increment table

	January	February (jan x 1.25)	March (Feb x 1.25)	April (Mar x 1.25)	May (Apr x 1.25)
Revenue	1000	1250	1562.50	1953.13	2441.41

As per HOMEWORKLIB RULES Experts cannot answer more then one question in one Q&A (Sub parts are answered). Please ask the second question seperately to get the answer from us.

Please comment an let me know if anymore explaination relating to Q1 is needed.

Thank You