Problem 1

You asked me to deposit $12,000 to you for the next five years. There are available options to deposit once a year or $1,000 monthly or $500 for every two weeks and to be made at the beginning or the end of each period. You prefer to make as much possible from this process.

Please explain what you do and why there are differences.

DIRECTIONS

You work for these two problems using EXCEL. You use one excel file with two sheets, one for each problem. After you complete your calculations, you provide your report in a WORD document. In your work document you explain clearly your work performed in EXCEL. Then you explain your suggestions. It would be helpful to include in your WORD document graphs presenting numerical analyses that were performed in EXCEL. Be clear, detailed, and professional.

Explain the financial concepts that your utilize for your analysis. Provide your work in EXCEL with ALL possible options that can be calculated. Explain the financial and mathematical formulas you use, as well as the EXCEL financial formulas.