Create the following charts by creating pivot tables from the Data Table tab
Create Area charts
1 Show Quarters by Category
2 Show Category by Quarters
3 Show Product by Quarters by the Category "Beverage".
Create pie charts
4 Show Products for the Catego
CASE 9
8/13/13
Student Version
CAMBRIDGE TRANSPLANT CENTER
Marginal Cost Pricing Analysis
This case analyzes a relatively straightforward marginal cost pricing analysis. It is designed
to illustrate the mechanics of estimating marginal costs as well as th
December 15, 2015
10-k Analysis Project
I.
a.
b.
c.
d.
e.
f.
Overview
Home Depot Inc., headquarters are located in Atlanta Georgia, incorporated in Delaware
Registered under the New York Stock Exchange, Common Stock, par value $0.05;
authorized: 10 billio
Midterm Exam-Fin305
Please upload exam and supporting work in to the midterm drop
box by 11.59 PM BY 3/15/2017
(I will prefer you upload one excel sheet containing all your
answers)
IMPORTANT:
It is an open book open notes exam. However, in the exam, you
Final-Group Project Fin305: Total points 300
You are a finance executive given the job of discussing attractiveness of two acquisition targets.
Pick Microsoft and Verizon.
(100 Points): Risk Return Framework (Due 3/10)
1.
2.
Collect the closing prices (ad
Worksheet Solutions
Comparing Regressive, Progressive, and Proportional Taxes
Theme 3: Fairness in Taxes
Lesson 5: How Taxes Affect Us
Key Terms
progressive taxA tax that takes a larger percentage of income from high-income groups
than from low-income gro
2.2
The Algebra of Functions
Dr. James Hager , Mathematics Department
The Sum, Difference, Product and Quotient of Functions
Let f and g be functions with domains A and B, respectively. The sum f + g, the
difference f g, and the product fg of f and g are
French 2
Course Objectives and Syllabus
FALL 2016
Instructor: Rita Mounzer
Instructors e-mail:
[email protected]
Section 006
Meeting times and place:
M. W. F (1:25-2:15)
Willard Bldg 171
T (2:oo - 2:50)
Hammond Bldg 206
Office Hours:
345Burrowes
M: 3:35-4:35
FR 02 criture #2 (First and Second Drafts)
This is a two-part writing assignment that requires students to compose a first and
second draft short writing task in class. Please see the details of each draft below.
Draft #1 Assignment: Write a 10-12 sentenc
How to Go Broke . While Making a Profit
Review the monthly results for APC Company. Take note that
APC Co. starts the year with $1,000 in cash and has a givemonth profit of $2,500. Reconcile the decline in cash. Where
does the cash go?
FIN 301: Corporate
Finance
Analyzing Financial Statements
Chapter
The Map of Financial Statement Analysis
Information
Sources
BS
IS
Stmt. of CF
Stmt. of RE
Footnotes
Auditors Rpt.
Industry Data
We begin by gathering relevant
information information.
The M
FIN 301: Corporate
Finance
Chapter 1: An Introduction to Financial
Management
Three Major Business Types
Sole proprietorship
Partnership
General
Limited
Corporation
S-Corp
Limited liability company
Sole Proprietorship
Advantages
Easiest to start
Least
Caldron, Inc.
2014 Income Statement
($ in millions)
Net Sales
$1,500
COGS
700
Depreciation
500
EBIT
300
Interest Exp. 100
NIBT
200
Taxes
80
NI
120
Dividends Paid
Caldron, Inc.
2013 and 2014 Balance Sheet
($ in millions)
Cash
Acct. Receivable
Inventory
Cur
CH 4 Practice Problems - 2
1. Assume the total cost of a college education will be $320,000 when your child enters college in 18
years. You presently have $50,000 to invest. What annual rate of interest must you earn on your
investment to cover the cost o
Chapter 6 Practice Problems 2
1. Osbourne Corporation has bonds on the market with 10.5 years to maturity, a YTM of 6.9%, and a
current price of $1,070. The bonds make semiannual payments. What must the coupon rate be on the
bonds?
2. If Treasury bills ar
Chapter 6 Practice Problems 3
1. Suppose your company needs to raise $45 million and you want to issue 20-year bonds for this
purpose. Assume the required return on your bond issue will be 7.5%, and you're evaluating two
issue alternatives: a 7.5% annual
Chapter 6 Practice Problems 1
1. Lycan, Inc., has 7% coupon bonds on the market that have 8 years left to maturity. The bonds make
semiannual payments. If the YTM on these bonds is 9%, what is the current bond price?
2. The Jackson Wardrobe Co. has 10% co
CH 5 PRACTICE PROBLEMS 2 Spring 2016
1. Nittany Bank charges 12.4 percent compounded monthly on its business loans. Cub Bank
charges 12.7 percent compounded semiannually. As a potential borrower, which bank has a
lower EAR?
2. Beaver Credit Bank wants to
Chapter 7 Practice Problems 1
1. Leslie's Clothing Stores offers a common stock that pays an annual dividend of $2.70 a share.
The company has promised to maintain a constant dividend. How much are you willing to pay
for one share of this stock if you wan
CH 3 Practice Problems
1. UnderWater has net working capital of $6,650 and current assets of $20,475. What is the current
ratio?
2. Safe Auto Parts has total assets of $825,860 and total debt of $445,200. What is the equity
multiplier?
3. Boyd, Inc., has
CHAPTER 4 Practice Problems - 1
1. Suppose you invest $100 for one year at 10% per year. What is the future value in one year?
Suppose you leave the money in for another year. How much will you have two years from now?
2. Suppose you had a relative deposi
CH 5 Practice problems 1
1. You think you will be able to deposit $4,000 at the end of each of the next three years in a bank
account paying 8 percent interest. You currently have $7,000 in the account. How much will you
have in 3 years?
How much will you
CHAPTER 2
Practice Problems
1) Building a Balance Sheet [LO 1]
Arredondo, Inc., has current assets of $2,310, net fixed assets of $10,700, current liabilities of $1,420,
and long-term debt of $4,120.
What is the value of the shareholders equity account fo
Pennsylvania State University Abington
FINANCE 301: Corporation Finance
Fall 2015
Mock Exam 3
Please write your first name and surname in BLOCK LETTERS in the space provided:
_
1.
2.
3.
4.
5.
A.
True
B.
next year's annual dividend divided by today's stock
Jason Tan
FIN 301
Homework 9
P9-18
A. D1 = $1.76 , Dividend Yield = $44 , Capital Gains Yield = 6%
B. The price of each stock will go up because the years of growth has increased, Dividend
will also increased due to more of the maximum growth potentials,
Jason Tan
FIN 301
Homework - Chapter 7
P7-19
A. Bond A : Discount
Bond B : Par
Bond C : Premium
B. Bond A : $856.79
Bond B : $1000
Bond C : $1143.21
C. Bond A : 8%
Bond B : 9%
Bond C : 9.6%
D. Bond A : PV - $863.90, Expect Capital Gain Yield - 0.8% , Expe
7-19
a) Bond A is discount. Bond B is Par. Bond C is Premium.
b) The price of each bond is:
a. Bond A is $856.79.
b. Bond B is $1,000.
c. Bond C is $1,143.21.
c) Bond yields:
a. Bond A= 8.99%
b. Bond B=9.0%
c. Bond C=9.0001%
d)
a. Price for each bond one