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

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

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