MRK516-W11B-Lab10

pdf

School

Seneca College *

*We aren’t endorsed by this school

Course

516

Subject

Finance

Date

Jan 9, 2024

Type

pdf

Pages

10

Uploaded by SargentScienceLark23

Report
PV Present Value $ -21,565 Interest rate (i) 3% Term (Year) (n) 5 Compounding periods per year 0 PMT 0 Future Value $ 25,000.00 FV Present Value $ -32,500 Interest rate (i) 4% Term (Year) (n) 7 Compounding periods per year 0 PMT 0 Future Value $ 42,767.78 PV Present Value $ -21,524 Interest rate (i) 5% Term (Year) (n) 3 Compounding periods per year 12 PMT 0 Future Value $ 25,000.00 FV Present Value $ -10,000 Interest rate (i) 4% Term (Year) (n) 10 Compounding periods per year 12 PMT 0 Future Value $ 14,908.33 FV Present Value $ - Interest rate (i) 5% Term (Year) (n) 1 Compounding periods per year 12 PMT $ -2,000 Future Value $ -
1 2 3 4 5 Initial investment $ (85,000.00) Cash in flows $35,000 $35,000 $35,000 $35,000 $35,000 required rate of return 12.00% Net PV $41,167.17 An investment that costs $85,000 will return $35,000 per year for 5 years. Determine the net present value of the investment if the required rate of return is 12%. (ignore taxes). Should the investment be undertaken?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
1 2 3 4 5 initial investment $ (195,000.00) cash flows -$195,000 $55,000 $55,000 $55,000 $55,000 $55,000 internal rate of return 12.67% required rate of return 10.00% Tanya Sinclair, owner of Sinclair Fine Wine, is considering investing $195,000 in a temperature-controlled storage room. She plans to rent space to customers and expects to generate $55,000 annually (rental cha miscellaneous expenses other than depreciation). Instructions: a) Assuming Tanya wishes to evaluate the project with a five-year time horizon, what is the internal rate o of the investment? (ignore taxes) b) Should Tanya make the investment if her required rate of return is 10%?
d wine arges less of return
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
initial investment $ 126,000.00 cash flows $21,000 payback peroid 6 The Sunny Valley Wheat Cooperative is considering the construction of a new silo. It will cost $126,000 to construct the silo. Determine the payback period if the expected cash inflows are $21,000 per year.
Year Project #1 Initial Investment Cash Flows Cumulative Cash Flow Net Present Value Internal Rate of Return Payback Period Project #2 Initial Investment Cash Flows Cumulative Cash Flow Net Present Value Internal Rate of Return Payback Period Project #3 Initial Investment Cash Flows Cumulative Cash Flow Net Present Value Internal Rate of Return Payback Period Project #4 Initial Investment Cash Flows Cumulative Cash Flow Net Present Value Internal Rate of Return Payback Period Project #5 Initial Investment Cash Flows Cumulative Cash Flow 0 1 2 3 4 5 6 7 8 $2,000,000 -$2,000,000 $400,000 $600,000 $600,000 $800,000 $600,000 $300,000 $0 $0 -$2,000,000 -$1,600,000 -$1,000,000 -$400,000 $400,000 $1,000,000 $1,300,000 $1,300,000 $1,300,000 $200,106.91 16.48% 3.5 $1,000,000 -$1,000,000 $600,000 $450,000 $250,000 $0 $0 $0 $0 $0 -$1,000,000 -$400,000 $50,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $56,652 16.83% 1.9 $2,500,000 -$2,500,000 $200,000 $400,000 $700,000 $1,100,000 $1,800,000 $2,100,000 $2,100,000 $2,100,000 -$2,500,000 -$2,300,000 -1900000 -$1,200,000 -$100,000 $1,700,000 $3,800,000 $5,900,000 $8,000,000 $2,818,235 31.13% 4.1 $1,250,000 -$1,250,000 $300,000 $450,000 $450,000 $200,000 $100,000 $0 $0 $0 -$1,250,000 -$950,000 -$500,000 -$50,000 $150,000 $250,000 $250,000 $250,000 $250,000 -$143,285 7.50% 3.3 $750,000 -$750,000 $700,000 $400,000 $0 $0 $0 $0 $0 $0 -$750,000 $50,000 $350,000 $350,000 $350,000 $350,000 $350,000 $350,000 $350,000
Year Net Present Value Internal Rate of Return Payback Period Project #6 Initial Investment Cash Flows Cumulative Cash Flow Net Present Value Internal Rate of Return Payback Period Project #7 Initial Investment Cash Flows Cumulative Cash Flow Net Present Value Internal Rate of Return Payback Period 0 1 2 3 4 5 6 7 8 $182,728 33.33% $1,000,000 -$1,000,000 $100,000 $400,000 $200,000 $700,000 $400,000 $400,000 $0 $0 -$1,000,000 -$900,000 -$500,000 -$300,000 -$400,000 $800,000 $1,200,000 $1,200,000 $1,200,000 $378,919 23.58% 3.4 $850,000 -$850,000 $350,000 $300,000 $300,000 $250,000 $250,000 $200,000 $200,000 $150,000 -$850,000 -$500,000 -$200,000 $100,000 $350,000 $600,000 $800,000 $1,000,000 $1,150,000 $429,113 28.90%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
PROJECT 1 2 3 4 5 6 7 Investment NPV IRR Payback -$2,000,000 $200,107 16.48% 3.50 -$1,000,000 $56,652 16.83% 1.89 -$2,500,000 $2,818,235 31.13% 4.06 -$1,250,000 -$143,285 7.50% 3.30 -$750,000 $182,728 33.33% 0.00 -$1,000,000 $378,919 23.58% 3.43 -$850,000 $429,113 28.90% 0.00