Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Directions: Answer the following nine questions in Microsoft Excel. Assume all investments / payments are made at the end of the month unless otherwise noted.
Directions: Answer the following nine questions in Microsoft Excel. Assume all investmentspayments are
made at the end of the month unless otherwise noted. You should use the videos, examples, and template provided on
Canvasto help guide you in answering these questions.
You must utilize the Excel functions discussed in the tutorial to perform all calculations.
Ensure that in the Excel file template that you use to answer the questions, you provide your first name,
your last name, and your student ID in dedicated cells.
Submissions that lack first name, last name, or student ID will automatically receive a zero.
Theminiproject is due on Friday, June by : PMand must be submitted via Canvas asxlsx file.
Ensure that your file is named properly with your full name and the project title eg
JohnDoeTVMProject.xlsx
Your projects must be your own individual work, although you may consult me if you get stuck.
Questions
Pawn America, a local pawn shop in town, lends money at an interest rate of percent per annum
that compounds interest weekly. What is the actual rate being charged on these loans?
A zerocoupon bond promises to pay $ in principal years from now. If interest rate are currently
at per year and expected to stay constant over time, at what price does the zero coupon bond trade?
You have an opportunity to purchase an annuity from an insurance company that offers to pay you
$ a year for years. If you want to earn a rate of return of at least what is the most you are
willing to pay today to buy this annuity?
Cirrus Aircraft estimates the cost of a new factory at $ million and wants it fully funded upfront.
Management has decided to save $ million per quarter for this purpose. Assume that the firm can earn
compoundedquarterly, on its savings. How many yearsdoesthe firm have to wait before expandingits operations?
Determine the internalrate ofreturn forthe following sequence of cashflows:
Year Cash Flow
$
$
$
$
$
$
If the cost of capital is should you accept or reject this project?
Determine the net present value to the following sequence of cash flows:
Year
Cash Flows $ $ $ $ $ $ $ $ $ $ $
Assume a cost of capital of On the basis of your calculation, should you accept or reject the project?
Suppose a friend of yours tells you that they have $ in student debt and have to make payment
of $ per month for the next years to completely pay the debt off. Based on this information,
determine the annual percentage rate your friend must be paying on their student debt.
Congratulations! You have just received your first job after college and have decided to start saving
for retirement. You have decided to contribute $ on the first of each month, starting today, to your
retirement account. Your employer will provide a percent match. In other words, your employer will add
$ to the amount you save each month. If both your employer and you continue to do this and you
believe you can earn an interest rate of per year compounded monthly, how much will you have in
your retirement account years from now?
Now that you have a job, you have decided to quit renting and buy a house. Suppose that you wish to
take out a mortgage to purchase a house worth $ Your bank agrees to lend you the money in the
form of a year mortgage with an annual interest rate. Given this information determine what your
monthly mortgage payment will beDirections: Answer the following nine questions in Microsoft Excel. Assume all investmentspayments are
made at the end of the month unless otherwise noted. You should use the videos, examples, and template provided on
Canvas to help guide you in answering these questions.
You must utilize the Excel functions discussed in the tutorial to perform all calculations.
Ensure that in the Excel file template that you use to answer the questions, you provide your first name,
your last name, and your student ID in dedicated cells.
Submissions that lack first name, last name, or student ID will automatically receive a zero.
The miniproject is due on Friday, June by : PM and must be submitted via Canvas as xlsx file.
Ensure that your file is named properly with your full name and the project title eg
JohnDoeTVMProject.xlsx
Your projects must be your own individual work, although you may consult me if you get stuck.
Questions
Pawn America, a local pawn shop in town, lends money at an interest rate of percent per annum
that compounds interest weekly. What is the actual rate being charged on these loans?
A zerocoupon bond promises to pay $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started