please include excel formula

1. Starting today, Nina is planning to invest Nina will earn is an annual $1,500 at the beginning of each year for 12 years. 10% on her investment. How much money would the investment be worth in today's dollars? Present your answer with a positive sign. Answer: ($10,220.54) 4.80%. 2. Bale Warehouse is offering a sofa for $6,300. The credit terms are 60 months at an annual interest rate of If you wish to purchase the sofa on credit, what is your monthly payment? Your answer should have a positive sign. Answer: ($26.71)