Looking for the excel function in Yellow on Q9 Question 9 Annual 3.000% Semi-Annual 3.022% Quarterly 3.034%
Fantastic news! We've Found the answer you've been seeking!
Question:
Looking for the excel function in Yellow on Q9
Transcribed Image Text:
Question 9 Annual 3.000% Semi-Annual 3.022% Quarterly 3.034% Monthly 3.042% 4 points Question 10 14.2 14.2 4 points 9) After reviewing the compounding model, your Kindergartener has a follow up question about effective annual rates. She figures with more frequent compounding, the effective annual rate cannot be 3% for all the compounding options. Calculate the effective annual rate for each of the compounding options in Question 8, using a function. (round to three decimal places) 10) A whistleblower exposed an illegal payoff scheme at a prison. The whistleblower's attorney believes his client could be eligible for a $3 million whistleblower pay out. The whistleblower believes this is a good start, but would need $6 million to retire comfortably, with the lifestyle he desires. If able to collect on the $3 million, how many years would it take to double his money to $6 million, assuming a 5% discount rate? Calculate this for him using an Excel function, not with the rule of 72. (round to the nearest tenth of a year) = Rate PMT PV FV 14.20669908 0.05 0 $3,000,000 $6,000,000 Question 9 Annual 3.000% Semi-Annual 3.022% Quarterly 3.034% Monthly 3.042% 4 points Question 10 14.2 14.2 4 points 9) After reviewing the compounding model, your Kindergartener has a follow up question about effective annual rates. She figures with more frequent compounding, the effective annual rate cannot be 3% for all the compounding options. Calculate the effective annual rate for each of the compounding options in Question 8, using a function. (round to three decimal places) 10) A whistleblower exposed an illegal payoff scheme at a prison. The whistleblower's attorney believes his client could be eligible for a $3 million whistleblower pay out. The whistleblower believes this is a good start, but would need $6 million to retire comfortably, with the lifestyle he desires. If able to collect on the $3 million, how many years would it take to double his money to $6 million, assuming a 5% discount rate? Calculate this for him using an Excel function, not with the rule of 72. (round to the nearest tenth of a year) = Rate PMT PV FV 14.20669908 0.05 0 $3,000,000 $6,000,000
Expert Answer:
Answer rating: 100% (QA)
SOLUTION 9 The formula for calculating the effective annual rate EAR is EAR 1 rnn 1 where r is the annual nominal interest rate and n is the number of ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
The first payroll in October covered the two workweeks that ended on September 26 and October 3. This payroll transaction has been entered for you in the payroll register, the employees' earnings...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
You are looking at buying a piece of real estate and you intend to borrow as much as you possibly can from a bank to buy the property. The bank you are dealing with has a requirement that the LVR for...
-
Using last-in, first-out; perpetual inventory costing; and the information presented in E2-6, compute the cost of materials used and the cost of the July 31 inventory.
-
Find the area of the shaded region under the standard normal curve. If convenient, use technology to find the area. -1.5
-
You became aware of the following control procedures for Gatehouse & Company's fixed assets: 1. All scrapped assets are agreed with published price lists before being offered for sale and are never...
-
Lincolnville Company uses an imprest petty cash system. The fund was established on March 1 with a balance of $100. During March the following petty cash receipts were found in the petty cash box....
-
1.10 Describe the three different types of clay minerals (kaolinite, illite, montmorillonite) described in the text and lecture. Explain why these three clay minerals are so different? 1.11 What is...
-
Factory work can be boring and monotonous. Employees must work at the pace of the assembly line or machine, with output levels closely prescribed and monitored by management. It is not surprising...
-
How do you build and maintain a positive credit history that leads to a high credit score? What changes could you make to improve yours? If you have a friend who is hoping to buy a home in the next...
-
Do you regard yourself to be a good listener? What might you do to improve your skills as a listener?
-
Answer the following questions only if you dont mind talking about this personal issue: Have you ever been a victim of sexual harassment? How did it make you feel?
-
Why will our company matter to customers? A complete answer to this question should say something about each of the following: How will you create customer value? What will be distinctive about the...
-
Find a recipe and mix up some bread dough. Is yeast one of the ingredients? (You may also be able to buy some fresh dough at a supermarket; some supermarkets sell dough for making pizza crusts.)...
-
Have you ever been the target of some form of workplace aggression? Why do you think this happened? What did you do to deal with it?
-
Details of Marvin v Marvin, the first "palimony" case, which took place in California in 1977. Please detail the facts of the case, the judgment, and the legal reasoning which led to the judgement.
-
Find the area of the surface generated by revolving the para- metric curve x = cos 1, y = sin? 1 (0 < I sa/2) about the y-axis.
-
Jim is fired from his job as a waiter and decides to take an extended trip to Europe. After touring Europe for 3 months, Jim returns to look for a new job as a waiter. Are his job-hunting expenses...
-
Dr. George E. Beeper is a single taxpayer. He lives at 45 Mountain View Dr., Apt. 321, Spokane, WA 99210. Dr. Beeper's Social Security number is 775-88-9531. Dr. Beeper works for the Pine Medical...
-
Ann hires a nanny to watch her two children while she works at a local hospital. She pays the 19-year-old nanny $125 per week for 48 weeks during the current year. a. What is the employer's portion...
-
White the torsion formula and give S.I. units of various terms.
-
A cast iron water main pipe \(12 \mathrm{~m}\) long, \(500 \mathrm{~mm}\) inside diameter and \(25 \mathrm{~mm}\) wall thickness runs full of water. It is supported at its ends. If the density of...
-
A rectangular cross-section beam has a width of \(100 \mathrm{~mm}\). Determine the depth of the beam so that maximum bending stress in the beam does not exceed \(35 \mathrm{MPa}\). The maximum...
Study smarter with the SolutionInn App