The project consists of two spreadsheets, each containing a separate problem. These problems are meant to get you some experience using the basic financial functions in Excel as well as familiarizing...

The project consists of two spreadsheets, each containing a separate problem. These problems are meant to get you some experience using the basic financial functions in Excel as well as familiarizing yourself with Excel help/resources. In addition to Excel’s help and documentation, you’ll find many resources available on the internet to help you. For instance, if you search YouTube for “naming cells in Excel” you’ll discover how to refer to cells using names you assign instead of referencing the row and column of the cell (this is problem #1). As you work through both problems, keep in mind that: A. You are expected to complete this assignment on your own. You may use texts and online resources, but you should not ask any person for help. I will answer clarifying questions about what a problem is asking for, but not how to complete it. Part of what I want you to experience in this exercise is finding the resources to help you solve problems on your own. B. Every function/calculation should link to a cell. Never type a value into a function/calculation or you won’t receive credit. As an example, don’t type “=PV(.1,5,-10)” but instead type “=PV(A1, A2, A3)” where the cells A1, A2, and A3 contain the relevant values needed for the present value function. C. If a cell is named, use the name in the reference. For instance, if A1 is named “Rate” then the present value formula should be written as “=PV(Rate, A2, A3)”. D. You should format cells according to their values (percentages, dollars, decimals, etcetera). Make certain that only two decimals are shown and that the thousands separator (numbers should display as 1,000 and not 1000). If you are sloppy with your formatting I will deduct 5 points.