Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Melissa agrees to make 12 deposits of $600 at the beginning of each month into a bank account. At the end of the 12th month,

image text in transcribedimage text in transcribed
image text in transcribedimage text in transcribed
Melissa agrees to make 12 deposits of $600 at the beginning of each month into a bank account. At the end of the 12th month, Melissa will have $8,284.50 in her account. If the bank compounds interest monthly, what nominal annual interest rate will Melissa be earning? (E) 32.45% I1 2.70% I' 1 25.68% I' 3' 19.44% Excel: = RATE(nper,pmt,pv,fv,type,guess) nper= number of months that Melissa will make deposits pmt= Melissa's monthly (a cash outflow) pv= Melissa's account balance; Melisa starts from nothing. fv= The amount that Melissa would like to have in her account at the end of 12 months type= 1 since the payments (deposits) come at the beginning of the period. The "RATE" function prompts you to make a guess. In many cases, you can omit it. Here you can simpy omit it as we illutrated in the PPT and the lectures. The rate you obtianed is the monthly rate; to get the annual rate we, have to multiply the monthly rate by 12

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso, Barbara Trenholm, Wayne Irvine

5th Canadian edition

978-1118024492

Students also viewed these Accounting questions