In Excel, create a TVM Calculator

List TVM Input including P$/$Y and annuity type $(0,1)$

Create Names for Input cells from Selection

Do formula to solve for each problem type

Have pull$-$down menu to select what you want to solve for

Use conditional formatting to cover up what you are solving for in the Input area

Depending on how you set things up$,$ you should hide $($group$)$ any extra solutions or work. Use XLOOKUP to show the desired solution based on the drop$-$down menu.

Upload your nicely formatted, fully functional TVM calculators here.

Be sure to review the handout on Excel Best Practices and the Excel Rubric!

Basically could you create a functional Time Value of Money calculator that follows the parameters above?