Question

Professor Wendy Smith has been offered the following deal: A law firm would like to retain...

Professor Wendy Smith has been offered the following deal: A law firm would like to retain her for an up-front payment of $50,000. In return, for the next year the firm would have access to eight hours of her time every month. Smith’s rate is $550 per hour and her opportunity cost of capital is 15% per year. What does the IRR rule advise regarding this opportunity? What about the NPV rule?

Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section.

PLZ I NEED THE FORMULAS AS THIS IS ON EXCEL.THANKS GREATLY

Up-front payment $50,000
Hourly rate $550
Hours per month 8
Opportunity cost 15%
Months in a year 12
Monthly rate of pay
IRR (monthly)
IRR (annual)
Take opportunity (Yes/No)
Monthly opportunity cost
NPV
Take opportunity (Yes/No)

Homework Answers

Know the answer?
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
Similar Questions
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain her for an upfront payment of $ 50 comma 000. In​ return, for the next year the firm would have access to eight hours of her time every month. As an alternative payment​ arrangement, the firm would pay Professor​ Smith's hourly rate for the eight hours each month. ​ Smith's rate is $ 550 per hour and her opportunity cost of capital is 15...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain her for an upfront payment of $ 50,000. In​ return, for the next year, the firm would have access to eight hours of her time every month. As an alternative payment​ arrangement, the firm would pay Professor​ Smith's hourly rate for eight hours each month. ​ Smith's rate is $ 555 per hour and her opportunity cost of capital is 15 % per year....
Professor Wendy Smith has been offered the following? opportunity: A law firm would like to retain...
Professor Wendy Smith has been offered the following? opportunity: A law firm would like to retain her for an upfront payment of $50,000. In? return, for the next year the firm would have access to eight hours of her time every month. As an alternative payment? arrangement, the firm would pay Professor? Smith's hourly rate for the eight hours each month. ?Smith's rate is $540 per hour and her opportunity cost of capital is 15% per year. What does the...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain her for an upfront payment of $ 50, 000. In​ return, for the next year the firm would have access to eight hours of her time every month. As an alternative payment​ arrangement, the firm would pay Professor​ Smith's hourly rate for the eight hours each month. ​ Smith's rate is $ 550 per hour and her opportunity cost of capital is 15 %...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain her for an upfront payment of $50,000. In​ return, for the next year the firm would have access to eight hours of her time every month. As an alternative payment​ arrangement, the firm would pay Professor​ Smith's hourly rate for the eight hours each month. ​ Smith's rate is $545 per hour and her opportunity cost of capital is 15% per year. What does...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain her for an upfront payment of $48,000. In​ return, for the next year the firm would have access to eight hours of her time every month. As an alternative payment​ arrangement, the firm would pay Professor​ Smith's hourly rate for the eight hours each month. ​ Smith's rate is $535 per hour and her opportunity cost of capital is 15% per year. What does...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain...
Professor Wendy Smith has been offered the following​ opportunity: A law firm would like to retain her for an upfront payment of $49,000.In​ return, for the next year the firm would have access to eight hours of her time every month. As an alternative payment​ arrangement, the firm would pay Professor​ Smith's hourly rate for the eight hours each month. ​ Smith's rate is $545 per hour and her opportunity cost of capital is 15% per year. What does the...
Your factory has been offered a contract to produce a part for a new printer. The...
Your factory has been offered a contract to produce a part for a new printer. The contract would be for three years and your cash flows from the contract would be $5 million per year. Your up-front setup costs to be ready to produce the part would be $8 million. Your cost of capital for this contract is 8%. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is...
You take out a 25-year mortgage for $300,000 to buy a new house. What will your...
You take out a 25-year mortgage for $300,000 to buy a new house. What will your monthly payments be if the interest rate on your mortgage is 8 percent? Now, calculate the portion of the 48th monthly payment that goes toward interest and principal. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year...
You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $800,000. The mortgage is currently exactly 18½ years old, and you have just made a payment. If the interest rate on the mortgage is 5.25% (APR), how much cash will you have from the sale once you pay off the mortgage? Complete the steps below using cell references to given data or previous calculations. In...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT