Course Project Part I
Introduction
The Course Project is an opportunity for you to apply concepts learned to a real-life simulation
experience. Throughout the Course Project, you will assume that you work as a financial analyst
for AirJet Best Parts, Inc.

Chapter 11
Problems 4, 7, 10
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 Excel

Report #3-104
November 5, 2015
123 Abc Street
Anywhere, Anystate 12345
(111)222-3333
TO: Mark Tads, Owner, Sunset Boards
FROM:
SUBJECT: Financial Statements
INTRODUCTION
This report consists of the financial statements for Sunset Boards for the 2013 and 2

Chapter 4: 8, 17, 18
Chapter 5: 1, 4, 12
8. Calculating Rates of Return.
In 2011 an 1880-O Morgan silver dollar sold for $13,113. What was the rate of return on
this investment.
r= (FV/PV)^1/t-1
r=(13,113/1)^1/131-1
r= .0751 or 7.51%
17. Calculating Prese

Chapter 8
Problems 5, 6, 11, 15, 28
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 i

Chapter 17
Question 6
Input Area:
Value of checks
Clearing time
Received payment
Clearing time
New clearing time
$
$
19,500
4
37,200
2
1
a. Disbursement float
Collection float
Net float
$
$
$
78,000
(74,400)
3,600
b. Disbursement float
Collection float
Ne

123 Abc Street
Anywhere, USA 12345
(111)222-3333
Report #3-105
November 20, 2015
TO: Mark Sexton and Todd Story, Owners, S&S Air, Inc.
FROM:
SUBJECT: Mortgage Recommendations
INTRODUCTION
This report consists of the evaluation of different mortgages. It w

Chapter 6
Problems 15, 16, 31
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 Exce

Calculating Cost of Equity (=Next Year's Dividends/stock price + dividends increase)
Beta
0.9
Market Risk Premium
7%
T-bills
3.50%
Dividend
$1.80 Per share, 5% increase annually, indefinitely
If Stock sales for $47 per share what is your best estimate of