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...
-
Calculate the following, round off to the correct number of significant figures, and express your result in scientific notation. (a) (2.00 10 4 )(6.10 10 2 ) (b) (3.141592)(4.00 10 5 ) (c) (2.32 ...
-
(a) Give an expression for the ambiguity function for a pulse train consisting of 4 pulses, where the pulse width is \(\tau^{\prime}=1 \mu s\), and the pulse repetition interval is \(T=\) \(10 \mu...
-
Refer to the data given for the Pruitt Company in Problem P12-3A. Required a. Compute the change in cash that occurred in 2019. b. Prepare a statement of cash flows using the direct method. Use one...
-
The Daniels Tool & Die Corporation has been in existence for a little over three years. The company's sales have been increasing each year as it builds a reputation. The company manufactures dies to...
-
Your event lighting company is thinking about investing in a bank of portable lights for sporting events. Your accounting department just brought you the following pro-forma accounting projections...
-
The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,000 Accounts receivable 20,000 Inventory 36,000...
-
A charter school system sets a standard for their schools graduation and retention rates in order for those schools to receive a certain amount of funding. Suppose the graduation rate established by...
-
Evelyn is a sales rep for an office equipment distributor and receives sales commissions of 2 . 5 % on the first $ 3 0 , 0 0 0 of sales in a month, 3 . 5 % on the next $ 3 0 , 0 0 0 , and 4 . 0 % on...
-
Solve the following system using Cramer's Rule. 2x+y+3 3 + 2 1 1 z = 1
-
discuss the evolution of mortgage servicing rights (MSRs) as a distinct asset class within the secondary mortgage market and the associated challenges and opportunities for investors, servicers, and...
-
Question # 3: [80 Marks] You all may have noticed the digits displayed on calculators and digital clocks. Every digit is derived from the digit '8'. 88:88 Consider that every point where two or more...
-
0 10:37 00 V 00200 DUKSTRA AND BELLMAN-FORD ROUTING AND STATIC ROUTING TABLE 35 53 10.0.0.0 4 9 OST 10.0.0.0 ND=2 NV=3 FIN 3 6 10.160.00 4 R **** 01 N SO 00serol 747 0 -2 4 7 10-176.0-0 3 E 8 4 8 10...
-
The expansion of a steel bridge as it is heated to a final Celsius temperature, TF, from an initial Celsius temperature, To, can be approximated by using this formula: Increase in length = axLx...
-
One Way Cellular accountants have assembled the following data for the year ended September 30, 2014: Prepare the operating activities section using the indirect method for One Way Cellulars...
-
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...
-
Repeat all parts of Problem 15.D12 but with a water rate of \(q=0.000015 \mathrm{~m}^{2} / \mathrm{s}\). Problem 15.D12 Water at \(20^{\circ} \mathrm{C}\) is flowing down a \(3.0 \mathrm{~m}\) long...
-
Repeat Problem 15.D12 but for \(\mathrm{q}=0.0015 \mathrm{~m}^{2} / \mathrm{s}\). a. Determine film thickness \(\delta\), average vertical velocity of film, and Reynolds number. b. Determine average...
-
We are measuring the diffusivity of water in air at \(42^{\circ} \mathrm{C}\). A tube is placed with one end in the water and the other end in a stream of dry air. The air column in the tube is...
Study smarter with the SolutionInn App