Question:Ashford 6: - Week 5 - Assignment

Hello,

Can you help me with the problem below. I need it to be completed on the attached spreadsheet. The numbers for the July/August course start dates need to be used. I also have copied the URLs that gives an explanation of the work if needed. Please let me know if there are any questions.

Thanks,

Chris

Week Five Assignment

1. Listen to the following videos and then complete the assignments using the changed numbers on the guidance report. Place your answers on the guidance report.
2. Open the Guidance Report and rework the problem with the changed numbers and place your answers on the guidance report. Do not alter the guidance report.
3. Submit the guidance report using the Assignment Submission tab below.

Complete the following problems and exercises:

• Chapter Eight Exercise 1
• Chapter Eight Exercise 3
• Chapter Eight Problem 3
• ChapterEightProblem4

Links to an explanation of how to work the problems:

http://ashford.mediaspace.kaltura.com/media/ACC206A+Chapter+8+Exercise+1/0_k3r52t52

http://ashford.mediaspace.kaltura.com/media/ACC206A+Chapter+8+Exercise+3/0_zwntp06u

https://ashford.mediaspace.kaltura.com/media/ACC206+Week+Five+Ch+8+Pb+3+v.2/0_92u0trhv

http://ashford.mediaspace.kaltura.com/media/ACC206A+Chapter+8+Problem+4/0_pks4jpsq

LISTEN TO AUDIO/VIDEO EXPLAINING THE GUIDANCE REPORT Exercise/ Problem Ch 8 Ex 1 Account to be changed Part A - Year 5 - Single cash flow Part B -Yearly amount - Annual receipt Part C - End of year 1 - Single receipt Part D - Annual receipt year 1 Questions Single cash flow: (Note: Use Excel NPV, enter rate and use a column with a zero amount for years 14(row 1-4)and 12000 entered in year 5(row 5) Annual receipt: (Note: Use Excel PV function.) Single receipt: (Note: use NPV and same approch as above.) Annual receipt: (Note: use NPV and same approch as above.) AUDIO/VIDEO EX 5