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

  Career plan in accounting & finance management

I must develop a career plan. My selected career is in Accounting & Finance Management. I would like a sample career plan relating to Accounting and Finance.

  Determine the interest expense

Determine the interest expense that Rainey Corporation will show with respect to these bonds in income statement for the fiscal year ended September 30, 2010, suppose amortized premium is $67,000.

  Calculation of the required ratios

Use formulas to compute ratios and format cells to insert comma if there is more than three (3) numbers. Give your answer to the nearest whole dollar.

  Explain the current reforms, their strength and weaknesses

You have been asked to write an article for The Economist analysing the debate initiated by Robert Shiller about democratising finance & comparing this with the kinds of regulatory measures

  Creating a decision tree

Mark is planning forecasts of expected economic growth. He plans to invest $120,000 in an investment whose return would depend on the economic situations.

  Calculation of break-even point

Susan Meyer, owner or manager of Meyer's Motor Court in Key West, is planning outsourcing the daily room cleanup for her motel to Duffy's Maid Service. Based on the data related to costs for every of the options, calculate the break-even point for Su..

  Multiple questions on accounting principles

Multiple questions on accounting principles - Carter Cleaning completed the following transactions: Purchased $18,000 of Office Supplies for $8,000 cash and the remainder on credit. Purchased equipment for $7,950 on credit. As a result of these tr..

  Calculate average rate of return for the stock

Spill Oil firm's stocks had -8 percent, 11 percent and 24 percent rates of return during the last 3-years respectively; find the average rate of return for the stock.

  Firm need to sell to reach the cash break-even point

Pringle Sock Company determines its break-even point strictly on the basis of cash expenditures related to fixed costs. Its total fixed costs are $700,000, but 25 percent of this value is represented by depreciation.

  Find the total expected dollar capital gain

Suppose Mr. Jim owns 1,500 shares of stock in corporation X. firm X's 18,750 shares outstanding are publicly sold and come with a pre-emptive right. They are currently trading at 27 dollar each share.

  What are some of the advantages of leasing

What are some of the advantages of leasing and how would you determine if a real-estate investment is profitable or not?

  Selection of optimal source of finance

Selection of optimal source of finance - Which plan do you recommend the company adopt?

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