## Just do my homework!

• HTML tags will be transformed to conform to HTML standards.
Question
Submitted by ramrog on Fri, 2012-05-18 16:10
due on Tue, 2012-05-22 16:07
Hand shake with neel: Complete
ramrog is willing to pay \$10.00
ramrog bought 15 out of 16 answered question(s)
More questions like this
 Finance 5

# Finance Class - 419

Please follow directions inside the attachments.. Must show all work

Attachments:
Submitted by neel on Tue, 2012-05-22 08:52
teacher rated 551 times
4.11434
purchased one time
price: \$27.00

Answer rating (rated one time)

5

## assignment as discussed with you-NEEL

body preview (3 words)

here you xxxxxxxxx

file1.xlsx preview (343 words)

# xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 Solution1 Cash Outflow = 10000000 Cash Inflow Year Amount xxxxxxxxxxx rate@9% PV Inflows 1 2500000 xxxxx xxxxxxx A x 2500000 xxxxx 2105000 3 xxxxxxx 0.772 1930000 x 2500000 0.708 xxxxxxx x 2500000 0.65 1625000 x xxxxxxx xxxxx 1490000 x xxxxxxx xxxxx 1367500 8 xxxxxxx 0.502 xxxxxxx Total Inflows xx PV xxxxxxxx xxxxx xxxxxxxx at xx xxxxxxxx xxx 4337000 xxxx xxxxxx xxxxxxxxxxx xxxxxxxx xx Inflows 1 xxxxxxx 0.901 2252500 b 2 xxxxxxx xxxxx 2030000.0000000002 x xxxxxxx 0.731 xxxxxxx 4 2500000 0.658 xxxxxxx 5 xxxxxxx xxxxx xxxxxxx x 2500000 xxxxx xxxxxxx x 2500000 xxxxx xxxxxxx 8 3500000 xxxxx xxxxxxx Total xxxxxxx xx PV xxxxxxxx xxxxx Outflows at PV 10000000 xxx 3296500 Year Amount xxxxxxxxxxx xxxxxxxx PV Inflows 1 xxxxxxx xxxxx xxxxxxx x 2500000 xxxxx xxxxxxx 3 2500000 xxxxx 1732499.9999999998 x© x 2500000 xxxxx xxxxxxx x 2500000 xxxxx xxxxxxx x 2500000 0.48 xxxxxxx x 2500000 xxxxx 1062500 8 xxxxxxx xxxxx xxxxxxx Total Inflows xx PV xxxxxxxx xxxxx Outflows at PV xxxxxxxx NPV 2371000 xxxx Amount Discounting rate@15% xx Inflows x 2500000 xxxxx 2172500 x xxxxxxx xxxxx 1890000 x xxxxxxx xxxxx 1642500 4 xxxxxxx xxxxx xxxxxxxxxxxxxxxxxx 1(d) 5 xxxxxxx 0.497 xxxxxxx x xxxxxxx xxxxx 1080000 x 2500000 0.376 940000 x 3500000 0.326 1141000 Total Inflows xx PV 11536000 Total xxxxxxxx xx PV xxxxxxxx NPV 1536000 xxxxxxxx 2 xxxx Amount xxxxxxxxxxx xxxxxxxx PV Inflows x xxxxx 0.869 15642 x xxxxx xxxxx xxxxx x xxxxx 0.657 11826 x 18000 xxxxx xxxxx 5 18000 0.497 8946 6 18000 0.432 7776 x 18000 xxxxx 6768 x 18000 xxxxx xxxx x 18000 0.283 5094 xx xxxxx 0.246 xxxx xxxxx xxxxxxx at xx 90234 xxxxx Outflows xx xx xxxxxx NPV -9766 xxxx xxxxxx xxxxxxxxxxx rate@10% xx Inflows 1 18000 xxxxx xxxxx x xxxxx xxxxx 14868 3 xxxxx xxxxx 13518 x xxxxx xxxxx 12294 x 18000 xxxx xxxxx x xxxxx 0.564 xxxxx x 18000 0.513 9234 x 18000 0.466 xxxx x 18000 xxxxx 7632 10 xxxxx 0.385 6930 xxxxx Inflows xx PV xxxxxx xxxxx xxxxxxxx

- - - more text follows - - -

file2.xlsx preview (119 words)

# xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 Solution: Capital Spending x xxxx of Project x Installation Cost = xxxxxxxxxxxxxx xxxxxxxxxxx Depreciation per xxxx = Capital xxxxxxxxxxxxxxx xx xxxxxx xxxxxxxxx x \$600,000 xxxxxxxxxxx of xxxx Flow per xxxx Year x 1 x 3 Capital Spending -\$1,800,000 xxxxxxxxx Cash Flows xxxxx (Units) 40000 65000 35000 xxxxx xxxxxxxx \$8,000,000 \$13,000,000 \$5,250,000 xxxxx xxxxxxxx xxxx \$5,200,000 xxxxxxxxxx xxxxxxxxxx Less: xxxxxxxxxxxx \$600,000 xxxxxxxx \$600,000 xxxxx Fixed Cost \$40,000 xxxxxxx \$40,000 xxxxxxx xxxxxx Tax \$2,160,000 xxxxxxxxxx \$60,000 Less: xxxxx \$864,000 xxxxxxxxxx \$24,000 Income xxxxx xxx \$1,296,000 \$2,346,000 \$36,000 Add: xxxxxxxxxxxx xxxxxxxx xxxxxxxx \$600,000 xxxxxxxxx Cash xxxxx \$1,896,000 \$2,946,000 xxxxxxxx Working xxxxxxx xxxxxxxxxxxx xxxxxxx xxxxxxx Initial -\$60,000 xxxxxxx Net xxxx xxxx -\$1,860,000 xxxxxxxxxx xxxxxxxxxx \$696,000 xx Its assumed xxxxxxx Working capital is recoverable at end of xxxx 3 xxx xxxxx be xxxxxxxx xx xxx beginning of xxxxx xx Determine xxx NPV and IRR xx the xxxxxxxx xxxx your xxxxxxxxxxxx in x Word xxxxxxxx xx xx xxxxx spreadsheet. Calculation of NPV xxxx Cash xxxx PV xxxxxx @ 10% xxxxxxx xxxxx x (\$1,860,000) 1.0000 (\$1,860,000) 1 \$1,896,000 xxxxx \$1,723,464 x xxxxxxxxxx 0.826 xxxxxxxxxx 3 xxxxxxxx xxxxx \$522,696 xxx \$2,819,556 IRR xxxxxx

# xxxxxx

 Buy this answer Try it before you buy itCheck plagiarism for \$2.00
Submitted by shahimermaid on Fri, 2012-05-18 18:06
teacher rated 387 times
4.322995
price: \$10.00

## the answer is explained in the simplest way in attached file

body preview (0 words)

file1.doc preview (246 words)

All questions must xx xxxxxxxxx in one Excel xxxxxxxxx

Redbird Capital Budgeting xxxxxxx

xxxxx identify or calculate the xxxxxxx xxxxxxxxx xxx xxxxxxxxx xxxx flow, the xxxxxx xx xxx xxxxxxx capital, xxx finally the xxxx cash flow to the firm xx xxx xxxxxxxx It xx these free xxxx xxxxx xxxx you xxxx that are discounted xx the weighted xxxxxxx xxxx of xxxxxxx to calculate the net present value and xxx xxxxxxxx rate of xxxxxxxx

You xxxx assess xxxxxxx to xxxx xxx xxxxxxxxxx xx xxxx xxx xxxx xxxxxxxxxxxxx xxxxx for xxx xxx present value xxx the xxxxxxxx rate xx return.

Redbird, Inc. xx considering xx xxxxxxxx xx xxx xxxxxxx operations. xxx xxxxxxx xxx xxxxxxx

xxxxxxxxxx
 xxxx of the xxx project \$1,700,000 Installation xxxxx xxxxxxxx xxxxxxxxx unit sales in xxxx 1 40,000 Estimated xxxx xxxxx xx xxxx 2 65,000 Estimated xxxx xxxxx in xxxx 3 xxxxxx Estimated sales price in xxxx 1 xxxx xxxxxxxxx sales price xx year x \$200 xxxxxxxxx xxxxx price xx xxxx x \$150 xxxxxxxx xxxx per

- - - more text follows - - -

file2.doc preview (942 words)

Week xxxx Individual Problems xxxxx

xxxxx To xxxxxxx xxxxxxx show xxxx xx all problems (It xxx xx shown as xxxxx xx financial calculator xxxxxx as xxxxx xx xxxxxx this sheet or in xxxxxx For instance, xx solving xxx xxx xx xx \$ 100 xx xx xxxx x xxxxxx xxx xxxxx demonstrate by listing xxx following: xx x xxxxx xxxx xxx and xx =133.82 (which xxxxx xx xxx xxxxxx).

xxCarson xxxxxxxx xx xxxxxxxxxxx xxxxxxx to expand its regional service center xx xxxxxx xxx The xxxxxxxxx requires xxx xxxxxxxxxxx xx xxxxxxxxxxx xx new service xxxxxxxxx and xxxxx xxxxxxxx annual xxx cash xxxxxxx xxxx reduced costs xx operations xxxxx xx xxxxxxxxxx per xxxx for xxxx of the xxxx eight years. In year eight the xxxx will xxxx xxx xxxx x xxxx xxxx xxxxx to xxx xxxxxxx xxxxx of the xxxxxxxxx xxxxx is xxxxxx xx \$1 xxxxxxxx xxxxx xx year eight xxx xxxxxxxxxx xxxx xxxxxx xxxxxx \$3,500,000. xxxxxxxxx xxx project’x NPV using xxxx of xxx following discount rates:

xxx

xxxx

13%

xxxx

xxBig Steve’xx xxxxxx of

- - - more text follows - - -

file3.xlsx preview (266 words)

# 1-8

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xx xxx @ xx xx PVF x xxx xx PVF xxxx xx PVF @ 15% xx year x (\$10,000,000) year x \$2,500,000 xxxxx xxxxxxxxxxx xxxxx 2252252.252 xxxxx 2212389.381 0.870 2173913.043 xxxx 2 xxxxxxxxxx xxxxx 2104199.983 xxxxx xxxxxxxxxxx xxxxx xxxxxxxxxxx xxxxx xxxxxxxxxxx xxxx x \$2,500,000 0.772 1930458.700 0.731 1827978.453 xxxxx 1732625.406 0.658 xxxxxxxxxxx year x \$2,500,000 0.708 1771063.028 0.659 xxxxxxxxxxx xxxxx xxxxxxxxxxx xxxxx xxxxxxxxxxx year x \$2,500,000 0.650 xxxxxxxxxxx xxxxx xxxxxxxxxxx xxxxx xxxxxxxxxxx xxxxx 1242941.838 year x xxxxxxxxxx xxxxx 1490668.317 xxxxx xxxxxxxxxxx xxxxx xxxxxxxxxxx 0.432 1080818.990 xxxx 7 xxxxxxxxxx 0.547 xxxxxxxxxxx xxxxx 1204146.027 xxxxx 1062651.609 xxxxx xxxxxxxxxx year 8 \$3,500,000 xxxxx xxxxxxxxxxx xxxxx xxxxxxxxxxx 0.376 1316559.516 0.327 1144156.208 xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxxxxxxxxxx xxxx 4338914.067 xxxxxxxxxxx 2373085.598 1545205.543 Q2) xxxxxxx xx PVF@15% PV xxxxxxx xx PVF@13% PV year 0 (\$100,000) xxxx 1 \$18,000 xxxxx xxxxxxxxx xxxxx 15652.174 0.893 16071.429 0.885 15929.204 year 2 xxxxxxx xxxxx xxxxxxxxx xxxxx 13610.586 xxxxx xxxxxxxxx 0.783 xxxxxxxxx year x \$18,000 xxxxx xxxxxxxxx 0.658 11835.292 xxxxx 12812.044 xxxxx 12474.903 year x xxxxxxx xxxxx xxxxxxxxx 0.572 10291.558 0.636 11439.325 xxxxx xxxxxxxxx xxxx 5 \$18,000 0.621 xxxxxxxxx 0.497 8949.181 xxxxx xxxxxxxxx 0.543 xxxxxxxx year 6 \$18,000 xxxxx 10160.531 0.432 xxxxxxxx 0.507 9119.360 0.480 xxxxxxxx xxxx x xxxxxxx 0.513 xxxxxxxx 0.376 6766.867 0.452 8142.286 xxxxx 7651.092 year 8 xxxxxxx xxxxx 8397.133 xxxxx 5884.232 0.404 7269.898 0.376 xxxxxxxx xxxx 9 \$18,000 xxxxx xxxxxxxx xxxxx 5116.723 xxxxx xxxxxxxx xxxxx xxxxxxxx year 10 \$18,000 0.386 6939.779 0.247 4449.325 xxxxx xxxxxxxx 0.295 5302.590 xxxxxxxxxx 90337.835 101704.015 97672.383 xxxx xxxxxxxxx -9662.165 xxxxxxxx -2327.617 12% Q3) PV xxxx xx PV@18% PV year x xxxxxxxxxx year x xxxxxxxx xxxxx xxxxxxxxxx xxxxx 148305.085 year

- - - more text follows - - -

 Buy this answer Try it before you buy itCheck plagiarism for \$2.00
Submitted by Smalhotra on Mon, 2012-05-28 05:57
teacher rated 0 times
0
price: \$10.00

## please find attachment

body preview (5 words)

xxxx xxxxxxxxxx xx xxxxx xxxxxx

file1.xlsx preview (121 words)

# xxxxxx

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxxxxxxxx xxxxxxx Spending = Cost xx Project x Installation xxxx = 1700000+100000 =\$18,00,000 xxxxxxxxxxxx per year x xxxxxxx xxxxxxxxxxxxxxx of Years= 1800000/3 = xxxxxxxx xxxxxxxxxxx of xxxx Flow per year Year 0 x x x xxxxxxx Spending xxxxxxxxxxx Operating Cash xxxxx xxxxx xxxxxxx 40000 xxxxx xxxxx xxxxx xxxxxxxx xxxxxxxxxx \$13,000,000 xxxxxxxxxx xxxxx xxxxxxxx xxxx \$5,200,000 \$8,450,000 \$4,550,000 Less: Depreciation xxxxxxxx \$600,000 \$600,000 xxxxx xxxxx Cost \$40,000 xxxxxxx \$40,000 Earning Before xxx \$2,160,000 xxxxxxxxxx \$60,000 Less: xxxxx \$864,000 xxxxxxxxxx \$24,000 Income After xxx xxxxxxxxxx xxxxxxxxxx \$36,000 Add: Depreciation \$600,000 xxxxxxxx xxxxxxxx xxxxxxxxx xxxx Flows xxxxxxxxxx \$2,946,000 \$636,000 Working xxxxxxx Requirements Working Capital Initial xxxxxxxx \$60,000 Net Cash Flow xxxxxxxxxxx \$1,896,000 xxxxxxxxxx \$696,000 xx Its xxxxxxx xxxxxxx Working capital is xxxxxxxxxxx xx end of year 3 xxx would be xxxxxxxx at the beginning of xxxxx xx xxxxxxxxx xxx NPV and xxx of xxx project. xxxx your xxxxxxxxxxxx xx a xxxx xxxxxxxx xx an Excel xxxxxxxxxxxxx xxxxxxxxxxx of xxx Year xxxx Flow xx Factor @ xxx xxxxxxx Value x xxxxxxxxxxxx 1.0000 (\$1,860,000) 1 \$1,896,000 0.909 \$1,723,464 x \$2,946,000 xxxxx xxxxxxxxxx 3 \$696,000 xxxxx xxxxxxxx xxx \$2,819,556 xxxxxxxxxxx xx IRR xxx

# xxxxxx

file2.xlsx preview (471 words)

# Sheet1

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
 xxx 1 xxxx xxxxxxx x xxxxxxxx Cash xxxxxx Year xxxxxx xxxxxxxxxxx xxxxxxx PV xxxxxxx x xxxxxxx xxxxxxxxxxxxxxxxxxx xxxxxxx x 2500000 0.84199999999999997 2105000 x 2500000 xxxxxxxxxxxxxxxxxxx 1930000 x xxxxxxx 0.70799999999999996 xxxxxxx x xxxxxxx 0.65 xxxxxxx 6 2500000 0.59599999999999997 1490000 7 xxxxxxx xxxxxxxxxxxxxxxxxxx 1367500 8 3500000 xxxxx xxxxxxx xxxxx xxxxxxx at xx xxxxxxxx xxxxx xxxxxxxx xx xx xxxxxxxx NPV xxxxxxx Year Amount xxxxxxxxxxx rate@11% PV Inflows x xxxxxxx xxxxxxxxxxxxxxxxxxx 2252500 x 2500000 0.81200000000000006 xxxxxxxxxxxxxxxxxx x 2500000 0.73099999999999998 xxxxxxx 4 xxxxxxx xxxxxxxxxxxxxxxxxxx xxxxxxx x 2500000 0.59299999999999997 xxxxxxx 6 2500000 0.53500000000000003 xxxxxxx x xxxxxxx xxxxxxxxxxxxxxxxxxx xxxxxxx x xxxxxxx 0.434 1519000 xxxxx Inflows xx PV 13296500 xxxxx xxxxxxxx at PV xxxxxxxx NPV 3296500 xxxx xxxxxx xxxxxxxxxxx xxxxxxxx PV Inflows x 2500000 0.88500000000000001 xxxxxxx x xxxxxxx xxxxxxxxxxxxxxxxxxx 1957500 3 xxxxxxx xxxxxxxxxxxxxxxxxxx 1732499.9999999998 4 2500000 0.61299999999999999 1532500 x 2500000 0.54300000000000004 xxxxxxx 6 xxxxxxx xxxx 1200000 x xxxxxxx 0.42499999999999999 1062500 8 xxxxxxx xxxxx 1316000 Total Inflows xx PV xxxxxxxx Total xxxxxxxx xx xx xxxxxxxx xxx 2371000 xxxx xxxxxx Discounting xxxxxxxx xx xxxxxxx 1 xxxxxxx 0.86899999999999999 xxxxxxx 2 xxxxxxx 0.75600000000000001 xxxxxxx 3 xxxxxxx 0.65700000000000003 1642500 4 xxxxxxx 0.57099999999999995 xxxxxxxxxxxxxxxxxx 5 2500000 xxxxx 1242500 6 2500000 0.432 xxxxxxx x 2500000 0.376 940000 8 xxxxxxx 0.32600000000000001 1141000 xxxxx Inflows at PV 11536000 Total xxxxxxxx at xx 10000000 NPV 1536000 xxx x xxxx xxxxxx Discounting rate@15% xx

- - - more text follows - - -

 Buy this answer Try it before you buy itCheck plagiarism for \$2.00