Question

Please show the work.

Thank you for your assistance!Durban Moving and Storage wants to have enough money available 6 years from now to purchase a new tractor-trailer. If the estimated cost will be $210,000, how much should the company set aside each year if the funds earn 11% per year The company should set aside $ each year.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E ゴWrap Text General aCopy B า 프 . Ej-., Δ. : r_一 逻锂函Merge & Center. $, % , 弼,8 Paste Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Font Alignment Number Styles Cells Edting GV244 GP GQ GR GS GT GU GV GW GX GY GZ 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 /4 | CALCULATOR , LOAN OPTIONS IT IS A CASE OF FUTURE VALUE ANNUITY FV RATE YEARS 210000 11% 6 USING EXCEL PMT USING FORMULA FVA-A/r*((1+r)An -1) 210000 A/0.11 ((1+0.11)A6- 1) 210000= A/0.11* 0.8704 26,539.08 PMT(GR232,GR233,,-GR231) 210000 *0.11/0.8704146 26539.08 HE COMPANY SHOULD SET ASIDE $26539.08 EACH YEAR CAP STRU VALUE BOX DILUTION DOLLAR COST AVG -MORTGAGE.. EXPO Sheet1 . Sheet2. Sh rences: x261 福 130% 12:01 19-01-2019

Add a comment
Know the answer?
Add Answer to:
Please show the work. Thank you for your assistance! Durban Moving and Storage wants to have...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Durban Moving and Storage wants to have enough money available 7 years from now to purchase...

    Durban Moving and Storage wants to have enough money available 7 years from now to purchase a new tractor-trailer. If the estimated cost will be $260.000. how much should the company set aside each year if the funds earn 14% per year? The company should set aside each year

  • Durban Moving and Storage wants to have enough money available 7 years from now to purchase...

    Durban Moving and Storage wants to have enough money available 7 years from now to purchase a new tractor-trailer. If the estimated cost will be $260,000, how much should the company set aside each year if the funds earn 14% per year? The company should set aside s e each year.

  • Problem 3 (20 Points Total) Durban Moving and Storage wants to have enough money available 5...

    Problem 3 (20 Points Total) Durban Moving and Storage wants to have enough money available 5 years from now to purchase a new tractor-trailer. (a) If the estimated cost is $250,000, how much should the company set aside each year if the funds earn 9% per year? (b) If the company can borrow money now at an interest rate of 9% to purchase the tractor-trailer at $225,000, how much should the company pay each year to pay off the 5...

  • 8. A computer company wants to have $2.1 million available 5 years from now to upgrade...

    8. A computer company wants to have $2.1 million available 5 years from now to upgrade the system. The company expects to set aside uniformly increasing amounts of money each year to meet its goal. If the amount set aside at the end of year 1 is $50,000, how much will the constant increase have to be each year? Assume the investment account grows at a rate of 18% per year. Draw cash flow diagram.

  • of per year How much could Ahmad's Construction Company afford to spend on new weet each...

    of per year How much could Ahmad's Construction Company afford to spend on new weet each year for the next 3 years if it expects a profit of $50 million 3 years from now? Assume the company's MARR is 20% per year ras Construction wants to have enough money available 5 years from now to purchase a ne ctor-trailer. If the estimated cost is $250,000, how much should the company set aside cac ar if the funds eam 10% per...

  • 1. A major drug company anticipates that in future years it could be involved in litigation...

    1. A major drug company anticipates that in future years it could be involved in litigation regarding perceived side effects of one of its antidepressant drugs. In order to prepare a war chest, the company wants to have $ 200 million available in 8 years from now. The company expects to set aside $11 million the fourth year and uniformly increasing amounts in each of the next 5 years. If the company can earn 12% per year on the money...

  • What is the equation to find the answers to these question? Thank you! Personal Finance Problem...

    What is the equation to find the answers to these question? Thank you! Personal Finance Problem ps-24 Funding your retirement Emily Jacob is 45 ycars old and has saved nothing for retire- ment account carring an 1 1% return. She will let the money ment. Fortunately, she just inherited $75,000. Emily plans to put a large portion of that money into an invest LG2 LG3 accumulate for 20 ycars, when she will be ready to retire. She would like to...

  • Please show all work in legible writing, thank you A couple wants to have $80,000 for their daughter to go to college i...

    Please show all work in legible writing, thank you A couple wants to have $80,000 for their daughter to go to college in 15 years from now. How much money should they put in the bank monthly, if they are getting 6% annual interest compounded monthly? Draw the cash flow diagram a) b) What should be the amount of uniform deposit done monthly?

  • please answer all questions from now to purchase electric landscaping equipment. If the estimated cost is $250,00...

    please answer all questions from now to purchase electric landscaping equipment. If the estimated cost is $250,000, how much should the college set aside each year if the funds earn 9% per year? Problem 3 Create an amortization table for a 3 year loan of $19,000 at 4.9% nominal interest compounded monthly. The table should include the date, remaining balance, pay period, interest payed during the payment period, principal payed in the payment period, and cumulative interest payed.

  • Apple Computer wants to have $3.1 billion available 7 years from now to finance oreduction finance...

    Apple Computer wants to have $3.1 billion available 7 years from now to finance oreduction finance production of a handheld "electronic brain" that, based on your behavior, will learn how to control nearly system. The company expects to set aside uniformly increasing amounts of to meet its goal. if the amount set aside at the end of year 1 is $45 million. all the electronic devices in your home, such as the thermostat, coffee pot, TV, and sprinkler money each...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT