Forecasted cash flows for alternative

Assignment Help Corporate Finance
Reference no: EM13200293

Technology Plus, LLC is evaluating three new product offerings.  Resources are available to do any or all of these. The forecasted Cash Flows for each alternative are shown below. Which one(s) should be approved if Internal Rate of Return is the sole criteria and a MARR of 20% is used?

Marr=20%

 

CASH FLOW

 

 

 

 

 

Project

Year

0

1

2

3

4

5

 

Model 4000

($75,000)

$20,000

$20,000

$20,000

$20,000

$20,000

 

Model 5000

($250,000)

$70,000

$80,000

$85,000

$85,000

$80,000

 

Model 6000

($5000,000)

$60,000

$100,000

$200,000

$2000,000

$2000,000

Please provide separate excel spreadsheets for each (5) question. ..Please.  I should have 5 excel spreadsheets.

Reference no: EM13200293

Questions Cloud

Regarding prions and mad cow disease : Which of the following is FALSE regarding prions and mad cow disease?
Most nominations today are made : most nominations today are made by
What role do inventories play in determining the real gdp : What role do inventories play in determining the real GDP demanded In answering this question, suppose initially that firms are either producing more than people plan to spend or producing less than people plan to spend.
Script ratios as fractions in simplest form : Solve. Write ratios as fractions in simplest form. For one month, a family spent $320 for food and $480 for rent. Find the ratio of the DIFFERENCE of the amount spent for food to the amount spent for rent.
Forecasted cash flows for alternative : Technology Plus, LLC is evaluating three new product offerings. Resources are available to do any or all of these. The forecasted Cash Flows for alternative.
What overall dimensions will minimize the amount : You are designing a rectangular poster to contain 256 in2 of printing with a 3-in. margin at the top and bottom and a 2-in. margin at each side. What overall dimensions will minimize the amount of paper used?
What is the maximum revenue : the number of widgets sells can be modeled by -5p+100 where p is the price of a widget. Revenue from sales is the product of the price and the number sold. What price will maximize the revenue? What is the maximum revenue?
What laws do some states enforce regarding lobbying : What laws do some states enforce regarding lobbying?
Explain an equation to represent the baker''s income : define an equation to represent the baker's income based on the number of loaves and muffins he makes. How many of each should he make for maximum income?

Reviews

Write a Review

Corporate Finance Questions & Answers

  How much should you place in the retirement fund

How much should you place in the retirement fund each year for the next 20 years to reach your retirement goal, assuming you can earn 12% per year on your retirement fund investment? Show your formulas and input

  Determine investments expected return

Carter Corporation is estimating a security. One-year Treasury bills are currently paying 9.1%. Determine the investment's expected return and standard deviation for security.

  Effect of leverage on creditors and share holders

Effect of leverage on creditors and share holders - As the firm levers up, how does the increase in value get apportioned between the creditors and the shareholders?

  Issuing or purchasing preferred stock

You are told that one corporation just issued 100m dollar of preferred stock & another purchased 100m dollar preferred stock as an investment.

  Calculation of gross interest cost and interest earned ratio

Calculation of gross interest cost and interest earned ratio and What would be the numeric adjustment(s), if any, to the Company's Consolidated Statement of Income and Consolidated Balance Sheet for minority interest in 2007?

  How businesses make capital budgeting decisions

What is meant by the statement The key to financial analysis is getting behind the numbers - what are some ways that cash is consumed by a business through financing activities?

  Determine company current stock price

Ziggs Company will pay a $3.85 per share dividend next year. The corporation pledges to increase its dividend by 4.75 percent per year, indefinitely.

  Current stock valuation modeling

Get the intrinsic values and make a recommendation to buy or hold the stock - Current stock valuation modeling

  Evaluate the optimal level of investment for a household

Evaluate total savings in each period.  Is the Investment/Saving market at equilibrium in each period?

  Calculate the value of each investment

Calculate the value of each investment based on your required rate of return and what required rates of return would make you indifferent to all three options?

  Prepare a income statement from trail balance

Preparation of income statement from trail balance and after adjustments and the companys CPA estimates that income taxes expense for the entire year is $7500 and Prepare an income statement

  Sole proprietorship, partnership, and corporation forms

Discuss the primary differences between partnership, sole proprietorship, and corporation forms of business ownership?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd