Amortization and Sinking Funds Applied Practice
Problem 1:
Loan Amortization
A sum of $100,000 is to be repaid over a 10-year period
equal installments made at the end of each year. If an interest rate of 10% pe
charged on the unpaid balance and interest

Present Value of an Annuity
Payment
100
Interest Rate
8%
Number of Payments
4
Present Value
($331.21)
Future Value of an Annuity
Payment
5500
Interest Rate
7.5%
Number of Payments
30
Future Value
$611,348.97
Solving for an Annuity Payment
Present Value
0

What is your monthly net income?
$2,800
How much "house" can you afford? The rule of thumb is that
you can buy housing that runs about two-and-one-half times
your annual salary.
$84,000.00
Go to www. har.com , www.zillow.com, or other area real
estate

Applying Break-Even Problems by Using the Goal Seek Feature in Excel
For each application, use the Goal Seek feature in Excel in your solution. Identify the variables
and equations in a text box. Conclude with a summary statement. Your work for each probl

Elvis Products International
Income Statement
For the Year Ended Dec. 31, 2014
2014
Sales
3,850,000
Cost of goods sold
3,250,000
Gross Profit
600,000
Selling and G&A Expenses
330,300
Fixed Expenses
100,000
Depreciation Expense
20,000
EBIT
149,700
Interest

Interest Practice Problems
Use Excel to solve each problem. Try to do both the mathematical formula as well
Problem 1:
$3,000 is invested at 7.2% interest. Find the total amount (A) at the end of 5 y
a.) Simple interest is earned.
pv=
3000
i=
7.20%
n=
5
I

Solving Linear Programming Applications With Desmos and Excel
For each application, choose meaningful variables, define them, and write the objective function and constraints.
Use the Desmos tool to find the feasible region and the corner points. Use Exce

TECH 3365
Depreciation and Depletion
Note:
Problem 1:
Some solutions below show values only; others show full formulas. When you submit your
assignment, be sure that all of your work and formulas are shown!
A building that was constructed for $12,000,000

Solving Linear Programming Applications With Excel's Solver Tool
Instructions: Use Excel's Solver Tool to solve each application. Each problem should consist of the following
components (outlined in the comment boxes below) and look similar to the followi

Applied Practice With Matrix Operations
For each applied problem, use Excel formulas and functions to calculate the solutions.
Problem 1: Two salepersons sell two models of new cars: luxury and compact. The August and
September gross dollar sales for each

Home Mortgage Spreadsheet Assignment
The purpose of this project is to investigate the cost of a home mortgage.
A couple has decided to purchase a home. The negotiated price is $175,0
The couple can pay the standard 20% down payment, and the rest will be

Elvis Products International
Ratio Analysis for 2013 and 2014
Ratio
2014
2013
Liquidity Ratios
Current Ratio
Quick Ratio
2.39x
0.84
2.33x
0.85
Efficiency Ratios
Inventory turnover ratio
Accounts receivable turnover ratio
Average collection period
Fixed as

Annuities Applied Practice
Problem 1:
IRAs If a merchant deposits $1000 annually at the end of each tax year in an
account paying interest at the rate of 6% per year compounded annually, how
in the account at the end of 25 years?
Payment
Interest Rate
6%

End of Month #
You charged this amount on a credit card. ->
The bill arrives and you make the 2% minimum payment. ->
Next month's bill = $9800 + intrest on the outstanding balance. ->
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27

Problem 1a
Mike Owjai Manufacturing
Income Statements
For the Years 2013 and 2014
Sales
Cost of Goods
Gross Profit
Depreciation
Selling & Admin. Expense
Lease Expense
Net Operating Income
Interest Expense
Earnings Before Taxes
Taxes
Net Income
Notes:
Tax

ETF List for FAME 7 | Release Date 10/24/2016 | 1 of 316
Fund Name
iShares MSCI All Country Asia ex Jpn Idx
iShares MSCI ACWI Index
iShares MSCI ACWI ex US Index
BLDRS Asia 50 ADR Index
BLDRS Developed Markets 100 ADR Index
BLDRS Emerging Markets 50 ADR I