Question
In: Finance
Work all the problems with a calculator (or spreadsheet) using the algebra equations and confirm your...
Work all the problems with a calculator (or spreadsheet) using the algebra equations and confirm your answer using the finance function available in your spreadsheet. The answers from both methods should be equal (within a small rounding error). Show what Algebraic Formula you use.
1. Find the present value of $125,000 you expect to receive 15 years from now using a discount rate of 7%. Write out the formula and use the power key, check with the Excel finance functions.
Show Work Formula Answer Spreadsheet fn
A. Discounted yearly: _______ _______
B. Discounted quarterly: _______ _______
C. Discounted monthly: _______ _______
Solutions
Expert Solution
a.
Present Value if discounted yearly = 125,000/(1 + 0.07)15 = $45,305.75
b.
Present Value if discounted quarterly = 125,000/(1 + 0.07/4)60 = $44,141.28
c.
Present Value if discounted monthly = 125,000/(1 + 0.07/12)180 = $43,875.86
jeff jeffy answered 2 years agoRelated Solutions
Find the following values, using the equations, and then work the problems using a financial calculator...
Find the following values, using the equations, and
then work the problems using a financial calculator to check your
answers. Disregard rounding differences. (Hint: If you are
using a financial calculator, you can enter the known values and
then press the appropriate key to find the unknown variable. Then,
without clearing the TVM register, you can "override" the variable
that changes by simply entering a new value for it and then
pressing the key for the unknown variable to obtain...
Find the following values, using the equations, and then work the problems using a financial calculator...
Find the following values, using the equations, and then work
the problems using a financial calculator to check your answers.
Disregard rounding differences. (Hint: If you are using a financial
calculator, you can enter the known values and then press the
appropriate key to find the unknown variable. Then, without
clearing the TVM register, you can "override" the variable that
changes by simply entering a new value for it and then pressing the
key for the unknown variable to obtain...
Find the following values, using the equations, and then work the problems using a financial calculator...
Find the following values, using the equations, and then work
the problems using a financial calculator to check your answers.
Disregard rounding differences. (Hint: If you are using a financial
calculator, you can enter the known values and then press the
appropriate key to find the unknown variable. Then, without
clearing the TVM register, you can "override" the variable that
changes by simply entering a new value for it and then pressing the
key for the unknown variable to obtain...
1.Find the following values, using the equations, and then work the problems using a financial calculator...
1.Find the following values, using the equations, and
then work the problems using a financial calculator to check your
answers. Disregard rounding differences. (Hint: If you are
using a financial calculator, you can enter the known values and
then press the appropriate key to find the unknown variable. Then,
without clearing the TVM register, you can "override" the variable
that changes by simply entering a new value for it and then
pressing the key for the unknown variable to obtain...
Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator
Calculate all of the
problems in the document below in an Excel spreadsheet or on a
financial calculator. Please show your work in order to get credit.
For each problem, state the inputs given, what you are being asked
to find (the missing input), and then use the Finance function to
get the correct answer (if using Excel).13. You are told that if you invest $15,000 per year for10 years
(all payments made at the end of each year), you...
Complete the following problems using either a financial calculator or a spreadsheet program. Do not use...
Complete the following problems using either a financial
calculator or a spreadsheet program. Do not use interim rounding,
state your answers as positive values, to two decimal places for
dollar or period values and four places for percentages stated as
decimals; do not label answers with symbols such as $ or %. For
example, “10.5%” should be input as “.1050”
1. Jacinda Herschel wants to buy a car and determines she can
afford to pay $295.02 a month for a...
Instructions Complete the following problems using either a financial calculator or a spreadsheet program. Do not...
Instructions
Complete the following problems using either a financial
calculator or a spreadsheet program. Do not use interim rounding,
state your answers as positive values, to two decimal places for
dollar or period values and four places for percentages stated as
decimals; do not label answers with symbols such as $ or %. For
example, 10.5% should be input as .1050.
An investment with quarterly compounding has a nominal rate of
0.0917. The effective rate is:
Complete the following problems using either a financial calculator or a spreadsheet program. Do not use...
Complete the following problems using either a financial
calculator or a spreadsheet program. Do not use interim rounding,
state your answers as positive values, to two decimal places for
dollar or period values and four places for percentages stated as
decimals; do not label answers with symbols such as $ or %. For
example, "10.5%" should be input as ".1050"
1. An investment compounding twice a month has an effective rate
of 0.1688. The nominal rate is:
2.Brian Burkhardt is...
*Complete the problems in an Excel spreadsheet. Be sure to show your work to receive credit;...
*Complete the problems in an Excel spreadsheet. Be sure
to show your work to receive credit; no hard keys.
Problem 2-1: Preparing Financial Statements
Information below is for Warner Manufacturing, Inc. for the year
ended December 31, 20x1 except where beginning of year numbers
indicated. All amounts in SAR unless otherwise stated.
Using the information below:
1. Prepare an income statement with the proper title
2. Prepare end of year balance sheet with the proper title
3. Calculate net working...
*Complete the problems in an Excel spreadsheet. Be sure to show your work to receive credit;...
*Complete the problems in an Excel spreadsheet. Be sure
to show your work to receive credit; no hard keys.
Problem 2-1: Preparing Financial Statements
Information below is for Warner Manufacturing, Inc. for the year
ended December 31, 20x1 except where beginning of year numbers
indicated. All amounts in SAR unless otherwise stated.
Using the information below:
1. Prepare an income statement with the proper title
2. Prepare end of year balance sheet with the proper title
3. Calculate net working...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A chemist has a substance which was either phenol or resorcinol. He puts the substance in...
- I need new and unique answers, please. (Use your own words, don't copy and paste), Please...
- Discuss system hardening strategies and techniques including updates and patches, default logon/passwords, anonymous access, removal of...
- What types of stories do you enjoy? Why are stories important?
- Read the privacy policy of a large, popular website. Write a brief summary. Identify the site...
- When σ is unknown and the sample is of size n ≥ 30, there are two...
- Draw a directed graph consisting of five nodes, each of which is path connected to every...
ADVERTISEMENT