Transcript
Instructions
- Add a target car buyer and estimated price range to your spreadsheet.
- Create columns for Loan Amount and Monthly Payment to create a table below the frozen rows.
- Enter a range of potential loans, increasing incrementally.
- Calculate the monthly payment for each loan amount using the PMT function.
- Change the monthly APR and loan term parameters to absolute instead of relative references.
- Copy the function to the rest of your spreadsheet.