EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI
EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI
8th Edition
ISBN: 9780176914943
Author: Mayes
Publisher: VST
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 12, Problem 4P

a.

Summary Introduction

Interpretation: Initial capital outlay, cash flows after tax and terminal cash flow of this project needs to be computed.

Concept introduction:Capital Budgeting technique is the most useful tool for financial management which helps to understand the investment in project is financially viable or not.

b.

Summary Introduction

Interpretation: Net present value, Profitability Index, IRR, MIRR, Payback period and discounted payback period needs to be computed.

Concept introduction: Capital Budgeting technique is the most useful tool for financial management which helps to understand the investment in project is financially viable or not.

Payback period 0.84

Discounted Payback period 0.9299

NPV $1,883,164

PI 3.8044

IRR 119%

MIRR 52%

Payback period: It is the period in which cash flow of investment covers the initial investment. It can be computed shown below:

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI, Chapter 12, Problem 4P , additional homework tip  1

Discounted payback period: It is the period in which discounted cash flow of investment covers the initial investment. It can be computed shown below:

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI, Chapter 12, Problem 4P , additional homework tip  2

Net present value: NPV is the sum of present value of the cash flows and initial investment when discounted at 11%. It can be computed as:

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI, Chapter 12, Problem 4P , additional homework tip  3

Profitability Index: It is used to analyze the profitability of an investment wherein its cash flow is divided by the initial investment It can be computed as:

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI, Chapter 12, Problem 4P , additional homework tip  4

IRR& MIRR: Internal rate of return is the expected return on the investment while MIRR is the rate of return after considering reinvestment rate. It can be computed as:

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI, Chapter 12, Problem 4P , additional homework tip  5

The formula used to compute IRR and MIRR is as follows:

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI, Chapter 12, Problem 4P , additional homework tip  6

c.

Interpretation: A scenario analysis is required.

Concept introduction: Capital Budgeting technique is the most useful tool for financial management which helps to understand the investment in project is financially viable or not.

1. Click on “Data” menu and select “scenario Manager” under “what if Analysis” option, then click on “add” option.Then rename the scenario name and select changing cells which need to replace.

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI, Chapter 12, Problem 4P , additional homework tip  7

2. Enter values which need to be resulted in that scenario, accordingly.

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI, Chapter 12, Problem 4P , additional homework tip  8

3. Then click on “summary” option to get the various scenario analysis.

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI, Chapter 12, Problem 4P , additional homework tip  9

4. Scenario Analysis will represent the final output in given scenario.

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI, Chapter 12, Problem 4P , additional homework tip  10

c.

Summary Introduction

Interpretation: A scenario analysis is required.

Concept introduction: Capital Budgeting technique is the most useful tool for financial management which helps to understand the investment in project is financially viable or not.

Blurred answer
Students have asked these similar questions
Oregon Equipment Company wants to develop a new log-splitting machine for rural homeowners. Market research has determined that the company could sell 6,000 log-splitting machines per year at a retail price of $700 each. An independent catalog company would handle sales for an annual fee of $2,000 plus $50 per unit sold. The cost of the raw materials required to produce the log-splitting machines amounts to $80 per unit. If company management desires a return equal to 10 percent of the final selling price, what is the target conversion and administrative cost per unit? Round answer to the nearest cent.
The Fleming Company, a food distributor, is considering replacing a filling line at its Oklahoma City warehouse. The existing line was purchased several years ago for $600,000. The line’s book value is $200,000, and Fleming management feels it could be sold at this time for $150,000. A new, increased capacity line can be purchased for $1,200,000. Delivery and installation of the new line are expected to cost an additional $100,000. Assuming Fleming’s marginal tax rate is 40%, calculate the net investment for the new line.
Burger King is looking to introduce a new veggie burger in Berwyn. Their analysts estimate that they will sell 12,000 veggie burgers per year. The unit cost per veggie burger is $0.58 and they plan on selling it for $2.5. If the current sales of meat burgers go down from 34,200 units per year to 28,600 units, what is the erosion cost? Assume that a meat burger costs $0.48 to produce and it sells for $2.0. Group of answer choices $12,511.00 $10,179.00 $2,978.00 $9,728.00 $8,512.00   Only typing answer Please answer explaining in detail step by step without table and graph thankyou

Chapter 12 Solutions

EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI

Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Text book image
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Text book image
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Capital Budgeting Introduction & Calculations Step-by-Step -PV, FV, NPV, IRR, Payback, Simple R of R; Author: Accounting Step by Step;https://www.youtube.com/watch?v=hyBw-NnAkHY;License: Standard Youtube License