Question: Solve Using Excel Present values ABC Corp. wishes to invest a fixed sum at 5.0% and withdraw $10,000 at the end of each month for

Solve Using Excel

Present values

ABC Corp. wishes to invest a fixed sum at 5.0% and withdraw $10,000 at the end of each month for the next three years. How much ABC will need to invest? In other words, what is the present value of an ordinary annuity of $10,000 for 36 periods, discounted at a rate of 5%/12 per period?

Assume that ABC Corp can earn 5%, but needs to withdraw $10,000 for 72, not 36 months. How much cash must it now invest to meet its $10,000 / month needs?

Assume that ABC Corp. can only earn 3.5% on its investment. What sum does it now need to invest to meet its $10,000 / month cash needs for 72 months?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Time Value of Money Kieso Intermediate Accounting 170 Must be submitted through Canvas in the form of an Excel worksheet no later than April 7,2021. Students will be assigned to groups of three or...

4. Compounding - Assume Lee, Inc. borrows $500,000 at 5.27% interest, compounded semiannually (twice per year). Lee, Inc. will repay the debt in a lump-sum at the end of an eight-year period. The...

6. Ordinary Annuities - Remember, ordinary annuities are amounts paid at the end of each period. a. Future values i. Advanced Engineering Group's cash flow forecast indicates that for the next 24...

5. Ordinary Annuities - Remember, ordinary annuities are amounts paid at the end of each period. a. Future values i. Advanced Engineering Group's cash flow forecast indicates that for the next 24...

Solve these problems in excel using either FV, NPER, NPV, PMT, PV, RATE. 1a. A local museum wishes to invest $100,000 of endowed funds for 10 years, with a goal of having $200,000 at the end of that...

ABC Corp. wishes to invest a fixed sum at 4.65% and withdraw $10,000 at the end of each month for the next three years. How much ABC will need to invest? In other words, what is the present value of...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

BELOW ARE MY QUESTIONS... P7 (8c) It is discovered that ACG's are essential for use in technology for detecting terrorist activities. As a matter of national security, Accounet allows the US...

A company is issuing a 3-year maturity bond that is expected to pay $40 every six month and a lump sum of $1000 at the end of three years from now. If bond investors require 5% annual nominal...

Please select two competitors of Truvia and fill out the competitive intelligence report in the Table below. Table of Competitors of Truvia Product Products Available Strengths of Product Competitive...

0 4 6 s i n c o s 2 d

On January 1, 2009, Affordable Financial, Inc., purchased the assets of Bisko Insurance Co. for $65,000,000, a price reflecting a $10,000,000 goodwill premium. On December 31, 2012, Affordable...

For each of the following situations, indicate the amount of revenue that the government should recognize in an appropriate governmental fund as well as in its government-wide statement of activities...

The Excel file Cell Phone Survey reports opinions of a sample of consumers regarding the signal strength, value for the dollar, and customer service for their cell phone carriers. Use PivotTables to...

Westor Company lost all of its inventory in a fire on December 28, 2017. The accounting records showed the following gross profit data for November and December: Westor is fully insured for fire...

JetBlue Airways Corporation (JBLU) operates passenger services throughout the United States. The following data (in millions) were adapted from recent financial statements of JetBlue. 1. Compute the...

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Product mix and overtime decisions Refer to the data for Crimson Components LO 1, 2 Company presented in Problem 5-42. The following additional information is available: The company believes that it...

Bid price (Adapted from CMA, June 1991) Marcus Fibers, Inc. specializes in the manufacture of synthetic fibers that the company uses in many products such as blankets, coats, and uniforms for police...

Product mix decisions (Adapted from CMA, December 1991) Bakker Industries sells three products (products 611, 613, and 615) that it manufactures in a fac tory consisting of four departments...