Question and Problem Sets Tanasja Gray - Finance for Business - Rich Tappe -9/18/2017
Ch. 18: Question 3 (Questions and Problems section)
3. Indicate the effect that the following will have on the operating cycle. Use the letter I to
indicate an increase,
Question and Problem Sets Tanasja Gray - Finance for Business - Rich Tappe -8/28/2017
Ch. 5: Questions 3 & 4 (Question and Problems section): Microsoft Excel templates
provided for Problems 3 and 4
3. Calculating Present Values [LO2] For each of the follo
Question and Problem Sets Tanasja Gray - Finance for Business - Rich Tappe -9/4/2017
Ch. 9: Question 7 (Questions and Problems section)
7. Calculating IRR [LO5] A firm evaluates all of its projects by applying the IRR rule. If the
required return is 14 pe
Ch. 9: Questions 7 & 8 (Questions and Problems section)
7. Calculating IRR [LO5] A firm evaluates all of its projects by applying the IRR rule. If the required return is 14 percent, should
the following project?
Year
0
1
2
3
Cash Flow
-$26,000
11,000
14,0
Chapter 5
Problems 1, 2, 3, 4, 5
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in E
Chapter 4
Problems 5, 6, 20, 22
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Ex
3. Indicate the effect that the following will have on the operating cycle. Use the letter I to indicate an increase, the letter
I
a. Average receivables goes up.
b. Credit repayment times for customers are increased.
c. Inventory turnover goes from 3 tim
1
WACC and Corporate Investment Decisions
Jasmine Sanders
FIN/370
08/07/2017
Mike Rodriguez
2
WACC and Corporate Investment Decisions
Financial planning is one of the most important jobs a company must complete. This
means deciding and forecasting beforeh
WACC and Corporate Investment Decisions
Financial planning is one of the most important jobs a company must complete. This
means deciding and forecasting beforehand the total number of funds that are accessible, the
amount available to spend, and how to p
Chapter 4
Problems 5, 6, 20, 22
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be installed in Ex
The gross profit margin is important for us to understand because it tells us if our sales
cover our costs. You generally want a high gross profit, especially for a new company. Kroger
has been around since 1883 ([his17], so their bottom line is a little
Kroger Financial Ratio Analysis
Financial Ratios
Current Ratio
Inventory Turnover
Debt Ratio
Time Interest Earned
Gross Profit Margin
Equity Multiplier
Return on Assets
Net Profit Margin
Return on Equity (DuPont Method)
Description
ysis
Year
2016
22%
1.54
Chapter 2
Problems 2, 3, 4, 6, 7, 14, 15, 19
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be in
FinancialRatioAnalysis
1
Fi
nancial Ratio Analysis
Danny
FIN/370
August 2, 2018
Professor Raymond
Financial Ratio Analysis
2
Financial Ratio Analysis
3
Financial Ratio Analysis
Financial Ratio Analysis
4
In order to determine and judge an organizations ov
Chapter 2
Problems 2, 3, 4, 6, 7, 14, 15, 19
Input boxes in tan
Output boxes in yellow
Given data in blue
Calculations in red
Answers in green
NOTE: Some functions used in these spreadsheets may require that
the "Analysis ToolPak" or "Solver Add-In" be in
1
Questions and Problem Sets
Reneco Bennett
FIN/370
June 19, 2017
Christine Gordon
2
Questions and Problem Sets
Chapter 5: Questions and Problems Section
3.)CalculatingPresentValues.Foreachofthefollowing,computethepresentvalue:
PresentValueYearsInterestRa
1
Weighted Average Cost of Capital Goup Assignment
Reneco Bennett
Kelly Gross
Megan Hess
Bradely Johnson
FIN/370
July 3, 2017
Trista Lilley
2
Weighted Average Cost of Capital
Introduction
The purpose of this proposal is to determine whether or not Vestor
When dealing with financial ratios and analysis, our job is to make sense of
the numbers and compute them in a way that we can use that information to
create a path for further understanding and growth. In this analysis for Lowes
Corporation, we will be e
What is WACC?
Weighted Average Cost of capital, the weighted average cost of equity, and the after tax
of cost of debt. The overall return that must be earned by the firm on the existing assets to
maintain the value of its stock. The required return on an
1
Questions and Problem Sets
Reneco Bennett
FIN/370
June 12, 2017
Christine Gordon
2
Questions and Problem Sets
Chapter 1 Concepts and Critical Thinking Questions 3 & 1
3.) Corporations. What is the primary disadvantage of the corporate form of
organizati
Chapter 18
Question 3
Changes in the Operating Cycle [LO1] Indicate
Indicatethe
theeffect
effectthat
thatthe
thefollowing
followingwill
willhave
have
on the operating cycle. Use the letter I to indicate an increase, the letter D for decrease
decrease,
and
Chapter 9
Question 7
Calculating IRR [LO5] A firm evaluates all of its by applying the IRR rule. If the required return is 14 percen
Year
Cash Flow
0
1
2
3
Required Return%
IRR
($26,000)
11,000
14,000
10,000
14
17%
The IRR is the interest rate that mankes
1
WACC and Corporate Investment Decisions
Reneco Bennett
FIN/370
July 3, 2017
Christine Gordon
2
WACC and Corporate Investment Decisions
One of the most important functions an organization should undertake is its financial
planning. It means forecasting a
1
WACC and Corporate Investment Decisions
Christina Behm
FIN/370
July 3, 2017
Tony Moses
WACC and Corporate Investment Decisions
2
For this assignment, I will demonstrate and be able to use the financial models I have
learned in this class to evaluate and
1
Questions and Problems Set
Christina Behm
FIN/370
June 26, 2017
Tony Moses
QUESTIONS AND PROBLEMS SET
2
Questions and Problems Set
Ch. 9: Questions 7 & 8 (Questions and Problems section)
7. Calculating IRR - A firm evaluates all of its projects by apply
1
Question and Problem Sets
Christina Behm
FIN/370
June 12, 2017
Tony Moses
QUESTION AND PROBLEM SETS
2
Question and Problem Sets
Ch. 1 Questions 3 & 11
3. Corporations - What is the primary disadvantage of the corporate form of
organization? Name at leas
1
WACC and Corporate Investment Decisions
Christina Behm
FIN/370
July 3, 2017
Tony Moses
WACC and Corporate Investment Decisions
2
For this assignment, I will demonstrate and be able to use the financial models I have
learned in this class to evaluate and
Gross profit margin indicates the percentage of revenue available to cover operating and other
expenditures. The gross profit margin at Lowes was 34.55% or 22464 million dollars this year and last
year it was 34.82% or 20570 million dollars. Lowe's Cos. I