Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What formula should I use to get the annual rate? Do I use the rate formula? Please show how. thank you! Which formula do I

What formula should I use to get the annual rate? Do I use the rate formula? Please show how. thank you!

image text in transcribed

Which formula do I use from this list?

image text in transcribed

DATA SECTION $ $ 1,500 Cash in Savings Monthly Deposits Term (years) Saving desired Annual Rate + $ 30,000 FINANCIAL FUNCTIONS FORMULA TOPIC PMI DESCRIPTION Calculates the payment for a loan ammortation 1 uprato,par pv.lv.type) 2 RATE RATE per pmtpv.lv.quess Calculates the role for a loan or savir PM doing a waving problem, the amount you will deposit savings each period. If doing loan problem, the amount you w re-pay each period. This numbers is always next NPER: Number of periods not number of years PV: Present value. If doing a saving problem, the amount you have in the bank at the beginning to be the number of doing loan problem, the amount you have borrowed a positive number FV: Future value. The amount you will have at the end of the number of periods if you are doing a savings problem of the amount you will owe at the end of the number of periods if you are doing a loan problem TYPE: Type of payment. 1 payments at the beginning of the period. Dat the end of the period Calculates the rate for a loan or saving Rate it is the interest rate/period PMT Amount paid per period NPER: Number of periods, not number of years Present Value FV] An optional argument which is about the future value of a loan if nothing is mentioned, FV is considered as "0" TYPE: Type of payment. 1 payments at the beginning of the period Butted at the pred 3 NPER NPER| Rato PMT PV IV. Type 4 PV pratenperpet, fv.type) Calculates the present value Rate for investment operano of pts for annuity payment is the amount of the payment made each period. If this parameter is omitted, you must enter a FV value FV is optional it is the luture value of the payments. If this parameters omitted the function assumes FV to be TYPEI Type of payment. I payments at the beginning of the period Osat the end of the period 5 NPV -NPV Rate Value 1 [Value 21. Value Cakulates the sum total of positive and negative cash flows over the years Rate Discount este for a period Value 1 Value 21.Value = Positive or negative cash flows Here, negative values would be considered as payments and portive values would be treated as inflows Calculates the cash flow when the payment and income are not Iperiodic Rate Discount rate for a period Values Positive or negative cash flows an array of values Dates Specific dates an array of dates 6 KNPV -XNPV Rate Values Dates 7 IRR Values, Gueul Calculate whether any new project or investment is profitable or not Values Positive or negative cash flow an array of values Guess) - An assumption of what you think I should be . TV chrole per pot.ptype) Calculates the future value Rare forvestment ne of pints for annuity CMT amount of pat made each period PV optional TYPE Type of payment. I payments at the beginning of the period O at the end of the period Allows a value to be placed if there is an error in a formula . CIFERRORe value error ERROR

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

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

12th Edition

9780073526706

Students also viewed these Accounting questions