(Answered) How to work this problem in excelnbspyou currently have

Finance

How to work this problem in excel

You currently have $13,820 in an investment account, with plans to liquidate the account during a period when equipment purchases will need to be funded during the off-season.

a. How long (in years or NPER) will you have to wait until your account is worth $24,000 if you can earn an annual return of 7.5 percent, with interest paid only once, at the end?

b. What is the length of time if you can have the interest compound monthly? You will need to divide the annual return by 12 when using Excel, and then with your answer, divide it by 12 to get the number of years.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92211898
Price:- $20

Verified Expert

Priced at $40 Now at $20, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Consider a 4-year annuity bond with annual cash payment of

Consider a 4-year annuity bond with annual cash payment of $100. It does NOT have a face value. Currently it sells for $316.98. What is the yield to maturity? Then assuming that periodic cash flows are reinvested at 10% ...

Question - we bought a stock for 4585 four years ago and we

Question - We bought a stock for $45.85 four years ago and we can sell it for $59.13 today. The stock does not pay dividends. What annual rate of return have we earned?

A stock can be sold for 1425 the investment bank charges

A stock can be sold for $14.25. The investment bank charges $1.10 per share for creating and marketing the shares. If the last dividend was $.91 and the growth rate is 2.1%, what is the cost of new common stock financing ...

How does a firm navigate strategic management in the

How does a firm navigate strategic management in the context of an international environment? What complications does an international environment provide? What are the benefits of operating in an international environme ...

Tapley dental supply company has the following datanet

Tapley Dental Supply Company has the following data: Net Income = $240 Sales = $10,000 Total assets = $6,000 Debt ratio = 75% TIE ratio = 2.0 Current ratio = 1.2 BEP ratio = 13.33% If Tapley could streamline operations, ...

Exerciseto hedge a short share position one can short the

Exercise To hedge a short share position, one can short the put option on the share. • What is the investor's intention in selling the put option? • What does the strike indicate when the trader has zero risk tolerance? ...

Joshua borrowed 500 on january 1 2017 and paid 25 in

Joshua borrowed $500 on January 1, 2017, and paid $25 in interest. The bank charged him a service charge of $10. He paid it all back at once on December 31, 2017. What was the APR? (Enter your answer as a percent rounded ...

Question - beaver company is investigating the purchase of

Question - Beaver Company is investigating the purchase of a new threading machine that costs $18,000. The machine would save about $4,000 per year and would have a salvage value of $3,000 in 6 years when the machine wou ...

One-year treasury bills currently earn 225 percent you

One-year Treasury bills currently earn 2.25 percent. You expected that one year from now, 1-year Treasury bill rates will increase to 2.75 percent and that two years from now, 1-year Treasury bill rates will increase to ...

Suppose you want to raise 15m for a new machine you plan to

Suppose you want to raise $15m for a new machine. You plan to raise the funds by selling 20-year $1,000 bonds with a semi-annual coupon rate of 5% and 8% yield. Before putting the bonds to market, inflation drops half a ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert