Question

PLEASE SHOW STEP BY STEP AND HOW TO SOLVE USING FINANCIAL CALCULATOR FUNCTIONS: You are a...

PLEASE SHOW STEP BY STEP AND HOW TO SOLVE USING FINANCIAL CALCULATOR FUNCTIONS: You are a marketing executive at a Boston based Marketing corporation. A client has come to you and said they would like to take on a marketing project if it will EFFECTIVELY earn them 10.00% per year. The project you proposed will cost $100,000 today and $20,000 next year (one year from today). The project will bring in equal cash flows starting next quarter, with the last cash flow anticipated to come in 8 years from today. How much do these cash flows need to be each quarter so that the client earns that EFFECTIVE 10% rate per year?

Homework Answers

Answer #1

rate compounded quarterly=(1.1^(1/4)-1)*4=9.6455%

Using financial calculator:

Step 1: FInd present value of outflow next year

N=4

FV=-20000

PMT=0

I/Y=9.6455%/4

CPT PV=$18,181.81386

Step 2: Find present value of outflows

=$18,181.81386+10000=$28,181.81386

Step 3: Find the cash flows each quarter

N=4*8

PV=-28,181.81386

FV=0

I/Y=9.6455%/4

CPT PMT=5341.783307

Alternatively, Using formula:

Cash flows=(100000+20000/((1+9.6455%/4)^4))*(9.6455%/4)/(1-1/(1+9.6455%/4)^(4*8))=5341.783307

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
Solve using a financial calculator: please show each step you use on the financial calculator! 1....
Solve using a financial calculator: please show each step you use on the financial calculator! 1. Given the following information, calculate the NPV for this property. Initial cash outflow: $200,000, Discount rate: 15%, CF for year 1: $25,876, CF for year 2: $23,998, CF for year 3: $23,130, CF for year 4: $22,105, CF for year 5: $144,670. Draw your cash flow diagram and show your steps used in financial calculator. 2. Suppose you purchased an income producing property for...
Please type not write step by step instructions using a BAII Plus Calculator and do not...
Please type not write step by step instructions using a BAII Plus Calculator and do not use Excel Answer is 13.74% I only want to learn the steps on a financial calculator. Ehrmann Data Systems is considering a project that has the following cash flow and WACC data. What is the project's MIRR? Note that a project's MIRR can be less than the WACC (and even negative), in which case it will be rejected. 13.74% WACC: 8.75% Year 0 1...
ABCD Inc. manufactures financial calculators. The company is deciding whether to introduce a new calculator. This...
ABCD Inc. manufactures financial calculators. The company is deciding whether to introduce a new calculator. This calculator will sell for $100. The company feels that sales will be 12,500, 13,000, 14,000, 13,200, and 12,500 units per year for the next 5 years. Variable costs will be 25% of sales, and fixed costs are $300,000 per year. The firm hired a marketing team to analyze the viability of the product and the marketing analysis cost $1,500,000. The company plans to use...
PLEASE SHOW HOW TO SOLVE USING FINANCIAL CALCULATOR. 20) Suppose Oppenheimer Bank is offering a 30-year...
PLEASE SHOW HOW TO SOLVE USING FINANCIAL CALCULATOR. 20) Suppose Oppenheimer Bank is offering a 30-year mortgage with an EAR of 6.80%. If you plan to borrow $150,000, what will your monthly payment be? 24) What is the present value (PV) of an investment today that pays $10,000 every year for four years, starting one year from today? Assume the interest rate is 7% APR, compounded quarterly. 25) You just deposited $2,500 in a bank account that pays a 12%...
Please show the step-by step calculation (as if you were using a financial calculator) to find...
Please show the step-by step calculation (as if you were using a financial calculator) to find out how much money is needed in lump-sum pay for two children's education (Age 10 and Age 12), assuming they begin college at age 18. Assume that inflation rate for tuition is 4.5%. Then, find out how much they would need in lump-sum if they had $40,000 for each child (80k total) and that money earned a 7% rate of return. Please show work...
How do i solve this with a BA II Plus financial calculator? A project that provides...
How do i solve this with a BA II Plus financial calculator? A project that provides annual cash flows of $1,000 for eight years costs $4,900 today. Is this a good project if the required return is 8%? What if it’s 24%? At what discount rate would you be indifferent between accepting the project and rejecting it?
Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known financial writer...
Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known financial writer Andrew Tobias argues that he can earn 200% per year buying wine by the case. Specifically, he assumes that he will consume one $10 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $10 per week or buy a case of 12 bottles today. If he buys the case, he receives a 10 percent discount and, by doing...
Fincal Inc. manufactures financial calculators. The company is deciding whether to introduce a new calculator. This...
Fincal Inc. manufactures financial calculators. The company is deciding whether to introduce a new calculator. This calculator will sell for $120. The company feels that sales will be 13,000, 13,000, 14,000, 14,000, 15,000 and 12,500 units per year for the next 6 years. Variable costs will be 30% of sales, and fixed costs are $200,000 per year. The firm hired a marketing team to analyze the viability of the product and the marketing analysis cost $2,000,000. The company plans to...
Part B: Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known...
Part B: Using only the Excel functions, please solve the following questions: 2. [Interest Rates]: Well-known financial writer Andrew Tobias argues that he can earn 200% per year buying wine by the case. Specifically, he assumes that he will consume one $10 bottle of fine Bordeaux per week for the next 12 weeks. He can either pay $10 per week or buy a case of 12 bottles today. If he buys the case, he receives a 10 percent discount and,...
You are the financial analyst for the Glad It’s Finally Over Company. The director of capital...
You are the financial analyst for the Glad It’s Finally Over Company. The director of capital budgeting has asked you to analyze a proposed capital investment. The project has a cost of $30,000 and the cost of capital is 10%. The project’s expected net cash flows are as follows: Year                Expected Net Cash Flow                            0                               ($30,000)                            1 12,500                            2 10,000                            3 10,000                            4 8,000 What is the project’s modified internal...