Question

You invest $1000 per month for 9 months starting 4 months from now (i.e., from month 4 to month 12), and then you increase yo

(F/P.1,6)= (1 + i) (1 + i) - 1 (P/1.1.7) = {(1 + i) (1 + i) - 1 (F/A,,n) = (P/G.i.n) = (1 + i)* – in 1 (1 + i) (A/G.1.n)

USE THE GIVEN FORMULAS WHENEVER POSSIBLE, NO Matlab or Excel solution

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

Here you are investing 100 every month starting from 4th month to 12th month then you increase your monthly investment by 100 per month starting from year 13 to 36 months

Interest rate = 60 % per year

Interest rate = 5% per month

PW = 100(P/A,5%, 33) (P/F,5%,3)+100(P/7,5%, 25) (P/F,5%, 11)

PW = 1, 382.36 + 7848.004247

PW = $ 9, 230.36

Now conerting it to equivalent annual worth

AW = PW(A/P,60%,3) = $ 9, 230,36 x 0.793798

AW = PW(A/P,60%, 3) = $ 7, 327.05

Please contact if having any query will be obliged to you for your generous support.

Add a comment
Know the answer?
Add Answer to:
USE THE GIVEN FORMULAS WHENEVER POSSIBLE, NO Matlab or Excel solution You invest $1000 per month...
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
  • Solve without Using excel/Matlab. solve using GIVEN formulas whenever APPLICABLE. ((Do not try to solve by...

    Solve without Using excel/Matlab. solve using GIVEN formulas whenever APPLICABLE. ((Do not try to solve by assuming each cash flow as a single cash flow at its corresponding year)) Problem 2 [20p]: A company offers the following two options to sell a car: Option 1: you do not have to make any payments for 6 months. After that att 6th month from now), you pay 3000 QR per month for 2 years. Option 2: you pay 1000 QR per month...

  • You invest $1000 per month for 9 months starting 4 months from now (i.e., from month...

    You invest $1000 per month for 9 months starting 4 months from now (i.e., from month 4 to month 12), and then you increase your investment by $100 per month for 2 years (i.e., from month 13 to month 36). If the rate of return is 60% per year, what is the equivalent annual worth ($ per year) of this cash flow in years 1 to 3?

  • 3000 3000 3000 3000 3000 2250 1688 1266 949 712 534 0 1 2 3 4...

    3000 3000 3000 3000 3000 2250 1688 1266 949 712 534 0 1 2 3 4 5 6 7 8 9 10 Solve without Using excel/Matlab. solve using GIVEN formulas whenever APPLICABLE. ((Do not try to solve by assuming each cash flow as a single cash flow at its corresponding year)) Problem 3 [20p]: A cash flow the attached diagram (where years). If the interest rate is 18% calculate the uniform series equivale A cash flow over 10 years is...

  • should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and...

    should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...

  • Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. Wha...

    Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car payments of $500 per month for 4 years...

  • second pic is the exhibit 1.5c provide formulas used 26. Variable labor budget: efficiency. If the assumed efficiency...

    second pic is the exhibit 1.5c provide formulas used 26. Variable labor budget: efficiency. If the assumed efficiency of the providers changed to 8570 (SEe A to 92% (see Exhibit I.5c.), what would be the productive capacity for January? EXHIBIT LSe CALCULATION OF RVU PRODUCTIVITY CAPACITY IN JANUARY Givens Physician Productivity 12 A Number of Physician I B Number of Physician II 8 204 C Shifts per year per full-time physician D Hours per shift per physician 10 15 E...

  • Show all excel formulas used Ex. 3 JIf a dealer offers you a car at $275...

    Show all excel formulas used Ex. 3 JIf a dealer offers you a car at $275 monthly payment for 5 years plus $5,000 down. If you can get a similar loan from a bank at APR of 12%, what is the price that you're paying? Down payment Monthly payment Loan period months APR No. of compounding times per year Monthly rate Present Value Book formula Excel function Ex. 4 If you take out an $10,000 car loan that call for...

  • lets suppose, My initial investment is 5,00,000 Rs and I invest 1,00,000 rs per month ....

    lets suppose, My initial investment is 5,00,000 Rs and I invest 1,00,000 rs per month . My investment earns 10 percent P. A. and after 3 year I increased my investment to 2,00,000 per month. and the intrest rate or return is same 10 percent per annum. After 6 years i startes to invest 3,00,000 rs per month and intrest rate or return is same. after 10 year i startes to invest 10,00,000 rs per month and intrest remains same....

  • Prepare depreciation schedules using Excel - Thanks in advance G H I J K L M...

    Prepare depreciation schedules using Excel - Thanks in advance G H I J K L M N O P Prepare depreciation schedules using Straight-line, Units-of-production, and double-declining balance depreciation. Make use of Excel capabilities by using as many formulas and functions as possible. Sullivan Ranch Corporation has purchased a new tractor. The following information is given: 1 150,000 10,000 Reference or given data section. 1,200 2 3 Cost: 4 Estimated Residual: 5 Estimated Life in years 6 Estimated Life in...

  • Please show me the work and formulas in the assigned cells. Thank you. C D E...

    Please show me the work and formulas in the assigned cells. Thank you. C D E On the cell B5 enter your PV, on cell B6 the annual retum rate on cell B7 the months of the year, and on the cell B9 calculate the monthly rate. On column C have the years, on column D the months of the year and on column E the periods. Calculate on column F the amount that you will have in your account...

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