need help w #2 a & b

need help w 2c and 2d please

B D N Number A 43 H 44 2a) (15 pts.) You want to save money to buy a new computer system. If you deposit $50 a month for 45 one year at an APR of 6.25% compounded monthly, answer the following in the green cells 46 provided. 47 48 Monthly Deposit 49 50 APR (as a percentage): % 51 52 APR (as a decimal): 53 54 time (in years): years 55 56 time (in months): months 57 58 2b) Using Cell References OR Excel Calculations (you can choose), answer the following in the BLUE cell. 59 60 Total Amount Deposited in one year: 61 62 2c) Complete the following table for one year, you MUST use Cell References to complete. 63 Interest Pald on 64 Month Deposit Balance 65 Previous Balance 66 Sheet1 1 HP Rand General Clipboard D137 Font Merge Center Alignment 4. Conditional Forma Formatting as Tab Nube 62 B D 2c) Complete the following table for one year, you MUST use Cell References to complete. 63 H 64 Month 65 Interest Paid on Previous Balance Deposit Balance 66 67 68 69 70 71 72 73 74 75 76 77 81 78 7920) Using Cell References OR Excel Calculations, answer the following in the BLUE cells. 80 Balance at the end of one year: 82 83 Total Interest made in one year: 84 85 3a) (15 pts.) You decide to buy a $26,000 car and can afford to bring a down payment of $4,000. The Sheet1