Show me how to post my homework

Just do my homework!

  • HTML tags will be transformed to conform to HTML standards.
  • Add rel="nofollow" to external links
Question
Submitted by sna200 on Thu, 2012-05-24 16:35
due on Mon, 2012-05-28 16:31
answered 2 time(s)
Hand shake with neel: Complete
Hand shake with mac123: In progress
sna200 is willing to pay $9.00
sna200 bought 2 out of 2 answered question(s)
More questions like this
Finance Class - 419
5

Finance

Note: To receive credit, show work on all problems (It can be shown as Excel or financial calculator inputs as well) on either this sheet or in Excel. For instance, if solving for the FV of $ 100 at 6% over 5 years, one could demonstrate by listing the following: PV = -100, N=5, I=6 and FV =133.82 (which would be the answer).

1)Carson Trucking is considering whether to expand its regional service center in Mohab, UT. The expansion requires the expenditure of $10,000,000 on new service equipment and would generate annual net cash inflows from reduced costs of operations equal to $2,500,000 per year for each of the next eight years. In year eight the firm will also get back a cash flow equal to the salvage value of the equipment which is valued at $1 million. Thus, in year eight the investment cash inflow totals $3,500,000. Calculate the project’s NPV using each of the following discount rates:

a. 9%

b. 11%

c. 13%

d. 15%

2)Big Steve’s, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine. This investment requires an initial outlay of $100,000 and will generate net cash inflows of $18,000 per year for 10 years.

a. What is the project’s NPV using a discount rate of 10%? Should

the project be accepted? Why or why not?

b. What is the project’s NPV using a discount rate of 15%? Should the project be accepted? Why or why not?

c. What is this project’s internal rate of return? Should the project be accepted? Why or why not?

3) Jella Cosmetics is considering a project that costs $800,000 and is expected to last for 10 years and produce future cash flows of $175,000 per year. What is the project’s IRR?

4)Microwave Oven Programming, Inc. is considering the construction of a new plant. The plant will have an initial cash outlay of $7 million (CF0 = –$7 million), and will produce cash flows of $3 million at the end of year 1, $4 million at the end of year 2, and $2 million at the end of years 3 through 5. What is the internal rate of return on this new plant?

5)Fijisawa, Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be $1,950,000, and the project would generate cash flows of $450,000 per year for six years. The appropriate discount rate is 9 percent.

a.Calculate the net present value.

b.Calculate the profitability index.

c.Calculate the internal rate of return.

d. Should this project be accepted? Why or why not?

6)The Callaway Cattle Company is considering the construction of a new feed handling system for its feed lot in Abilene, Kansas. The new system will provide annual labor savings and reduced waste totaling $200,000 while the initial investment is only $500,000. Callaway’s management has used a simple payback method for evaluating new investments in the past but plans to calculate the discounted payback to analyze the investment. Where the appropriate discount rate for this type of project is 10 percent, what is the project’s discounted payback period?

7) The Bar-None Manufacturing Co. manufactures fence panels used in cattle feed lots throughout the Midwest. Bar-None’s management is considering three investment projects for next year but doesn’t want to make any investment that requires more than three years to recover the firm’s initial investment. The cash flows for the three projects (Project A, Project B, and Project C) are found below: (SHOW WORK/CALCULATIONS TO DEMONSTRATE ANSWER RATIONALE)

Year Project A Project B Project C

0 $(1,000) $(10,000) $(5,000)

1 600 5,000 1,000

2 300 3,000 1,000

3 200 3,000 2,000

4 100 3,000 2,000

5 500 3,000 2,000

a.Given Bar-None’s three-year payback period, which of the projects qualify for acceptance?

b.Rank the three projects using their payback period. Which project looks the best using this criterion?

c.If Bar-None uses a 10% discount rate to analyze projects, what is the discounted payback period for each of the three projects? If the firm still maintains its three-year payback policy for the discounted payback, which projects should the firm undertaken?

8)You are considering a project with an initial cash outlay of $80,000 and expected cash flows of $20,000 at the end of each year for six years. The discount rate for this project is 10%.

a.What are the project’s payback and discounted payback periods?

b.What is the project’s NPV?

c.What is the project’s PI?

d.What is the project’s IRR?

Answer
Submitted by neel on Fri, 2012-05-25 15:06
teacher rated 530 times
4.18302
purchased 4 times
price: $9.00

Answer rating (rated one time)

5

Answer-100% correct solution from a CPA and CFA

body preview (3 words)

xxxx x go..,,

file1.xlsx preview (581 words)

Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxx 1
xxxxxxx xxxx Outflow xxxxxxxx
Year xxxxxxDiscounting xxxPV
0 xxxxxxxxx x xxxxxxxxx
1 xxxxxxx0.9174 2293500
2 xxxxxxx 0.8417 2104250
xxxxxxxx xxxxxx1930500
4xxxxxxx0.7084 1771000
x 2500000 0.6499 xxxxxxx
xxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxx
7 xxxxxxxxxxxx 1367500
8xxxxxxx xxxxxx xxxxxxx
NPV xxxxxxx
xxxxAmount Discounting xxxxPV
0xxxxxxxxx 1-10000000
xxxxxxxx 0.90092252250
x 2500000xxxxxxxxxxxxx
xxxxxxxx0.73121828000
4 xxxxxxxxxxxxx 1646749.9999999998
x2500000 xxxxxx1483500
x xxxxxxx 0.5346 xxxxxxx
x 25000000.48161204000
x xxxxxxxxxxxxx1518650
xxx xxxxxxx
xxxxAmount xxxxxxxxxx xxxxxx
xxxxxxxxxx 1-10000000
x xxxxxxx xxxxxx xxxxxxx
2 xxxxxxx0.7831 1957750
xxxxxxxx xxxxx1732499.9999999998
x25000000.6133 xxxxxxx
x xxxxxxx0.5427 1356750
x 25000000.4803xxxxxxx
x2500000xxxxx xxxxxxx
8 3500000xxxxxx 1316350
xxx2372100
Year xxxxxxxxxxxxxxxx xxxxxx
x-10000000 1-10000000
x xxxxxxx xxxxxxxxxxxxx
x xxxxxxx xxxxxx1890250
3 xxxxxxxxxxxxx1643750
4xxxxxxx0.5717 1429250
5 xxxxxxx xxxxxx1242750
6xxxxxxxxxxxxx xxxxxxx
x2500000 0.3759939750
83500000xxxxxx xxxxxxx
xxxxxxxxxx
xxxxxxx 2
xxxx Amountxxxxxxxxxx @15%PV
0xxxxxxx xxxxxxxx
xxxxxx0.869515651
2xxxxx0.7561xxxxxxx
x xxxxx 0.6575 11835
x180000.5717 xxxxxxx
5xxxxx0.4971xxxxxx
6 18000 0.4323xxxxxx
7 xxxxx 0.37596766.2
xxxxxx xxxxxx5884.2
9xxxxx 0.2842xxxxxx
xx18000 0.24714447.8
NPVxxxxxxxxx xxxx xxxxxxx xxx xxx xx xxxxxxxx because of negative xxx xx the project.
xxxx xxxxxx Discount

- - - more text follows - - -



Buy this answer

Try it before you buy it
Check plagiarism for $2.00

Answer
Submitted by shahimermaid on Thu, 2012-05-24 21:24
teacher rated 378 times
4.34656
purchased one time
price: $9.00

the answer is explained in the simplest way and is attached

body preview (0 words)

file1.docx preview (999 words)

xxxx Four Individual xxxxxxxx (1-8)

Note: xx receive credit, show work xx xxx problems (It can xx shown as Excel xx financial xxxxxxxxxx inputs xx xxxxx on xxxxxx xxxx sheet xx in Excel. xxx xxxxxxxxx xx xxxxxxx xxx xxx FV of $ xxx at xx over x years, xxx xxxxx demonstrate by listing the following: PV = xxxxx xxxx xxx xxx FV xxxxxxx xxxxxx would xx the answerxx

1)xxxxxx Trucking is xxxxxxxxxxx whether xx xxxxxx xxx regional service xxxxxx xx xxxxxx xxx xxx xxxxxxxxx xxxxxxxx the expenditure xx xxxxxxxxxxx xx new xxxxxxx xxxxxxxxx and xxxxx xxxxxxxx xxxxxx xxx xxxx inflows xxxx xxxxxxx xxxxx xx xxxxxxxxxx xxxxx xx $2,500,000 xxx year xxx each of xxx next eight xxxxxx xx xxxx xxxxx xxx firm will also xxx back x cash xxxx equal xx xxx salvage xxxxx xx the equipment which is

- - - more text follows - - -



Buy this answer

Try it before you buy it
Check plagiarism for $2.00