Date: May 19, 2016
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,000 The couple can pay the
standard 20% down payment,

Question 1
1 out of 1 points
What are the required class prerequisites? (If you do not have these prerequisites, contact your
advisor immediately before you are administratively withdrawn from the class.)
Question 2
1 out of 1 points
What are the require

Question 1
1 out of 1 points
Two numbers are stored in cells A1and A2. Write an Excel formula that will find the
product of this set of numbers.
Selected
Answer:
Answers:
=A1*A
2
=
A1+A2
=A1
A2
=A1*A
2
=A1/A2
Question 2
1 out of 1 points
When calculating

Problem 3: A manufacturing company produces two types of inflatable boats, a 2-person boat and
a 4-person boat. Each 2-person boat requires 0.9 labor-hours from the cutting department and
0.8 labor-hours from the assembly department. Each 4-person boat re

Anum Naveed
Problem 1: A hospital patient is required to have at least 84 units of Drug A and and 120 units of Drug B.
Each gram of substance M contains 10 units of Drug A and 8 units of Drug B. Each gram of substance N
contains 2 units of Drug A and 4 un

Problem 8: An electronics firm manufactures two types of personal tablets, the standard size and the
mini size. The production of a standard size requires a capital expenditure of $40 and 4 hours of labor.
The production of a mini size requires a capital

Problem 5: A fast-food chain has plans to expand by opening several new restaurants. The chain
operates two types of restaurants, drive-through and full-service. A drive-through restaurant costs
$150,000 to construct, requires 5 employees, and has an expe

ANUM
NAVEED
EXHIBIT 7-1
1
2
3
4
5
A
B
FUTURE VALUE CALCULATION
PRESENT VALUE
$
1,000.00
YEARS
1
RATE
10%
FUTURE VALUE
$1,100.00
1
2
3
4
5
A
B
FUTURE VALUE CALCULATION
PRESENT VALUE
$
1,000.00
YEARS
2
RATE
10%
FUTURE VALUE
$1,210.00
1
2
3
4
5
A
B
FUTURE VA

Mike Owjai Manufacturing
Common-size Income Statements
For the Years 2013 and 2014
2014
Sales
100.00%
Cost of Goods
64.95%
Gross Profit
35.05%
Depreciation
2.40%
Selling & Admin. Expense
24.85%
Lease Expense
1.86%
Net Operating Income
5.94%
Interest Expen

Problem 2: A chicken farmer can buy a special food mix A at 20 cents per pound and a special food mix B
at 40 cents per pound. Each pound of mix A contains 3000 units of nutrient N1 and 1000 units of nutrient N2.
Each pound of mix B contains 4000 units of

Problem 3: A manufacturing company produces two types of inflatable boats, a 2-person boat and
a 4-person boat. Each 2-person boat requires 0.9 labor-hours from the cutting department and
0.8 labor-hours from the assembly department. Each 4-person boat re

Problem 8: An electronics firm manufactures two types of personal tablets, the standard size and the
mini size. The production of a standard size requires a capital expenditure of $40 and 4 hours of labor.
The production of a mini size requires a capital

Problem 10: A financial company has a total of $20 million earmarked for homeowner and auto loans.
On the average, homeowner loans have a 10% annual rate of return, whereas auto loans yield a 12%
annual rate of return. Management has also stipulated that

Problem 9: A restaurant sells a luncheon casserole that consists of 50% carbohydrates, 30% protein, and 20% fat. Its dinner
casserole consists of 75% carbohydrates, 20% protein, and 5% fat. The luncheon casserole costs $2.00 per pound and the dinner
casse

Problem 7: A manufacturing company makes two types of water skis, a trick ski and a slalom ski.
The relevant data is summarized in the table below. How many of each type of ski should be
manufactured each day in order to maximize profit? What is the maxim

Problem 5: A fast-food chain has plans to expand by opening several new restaurants. The chain
operates two types of restaurants, drive-through and full-service. A drive-through restaurant costs
$150,000 to construct, requires 5 employees, and has an expe

Problem 4: An investor has $24,000 to invest in bonds of AAA quality and B quality. The AAA bonds
yield and average 6% return and the B bonds yield an average 10% return. The investor requires that
at least three times as much money should be invested in

Problem 1: A hospital patient is required to have at least 84 units of Drug A and and 120 units of Drug B.
Each gram of substance M contains 10 units of Drug A and 8 units of Drug B. Each gram of substance N
contains 2 units of Drug A and 4 units of Drug

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

Problem 6: A city council voted to conduct a study on inner-city community issues. A nearby university
was contacted to provide sociologists and research assistants. Allocation of time and costs per week are
summarized in the table below. The hourly wages

Problem 7: A manufacturing company makes two types of water skis, a trick ski and a slalom ski.
The relevant data is summarized in the table below. How many of each type of ski should be
manufactured each day in order to maximize profit? What is the maxim

Problem 9: A restaurant sells a luncheon casserole that consists of 50% carbohydrates, 30% protein, and 20% fat. Its dinner
casserole consists of 75% carbohydrates, 20% protein, and 5% fat. The luncheon casserole costs $2.00 per pound and the dinner
casse

Problem 10: A financial company has a total of $20 million earmarked for homeowner and auto loans.
On the average, homeowner loans have a 10% annual rate of return, whereas auto loans yield a 12%
annual rate of return. Management has also stipulated that

Elvis Products International
Balance Sheet
As of Dec. 31, 2014
Assets
Cash and Equivalents
Accounts Receivable
Inventory
Total Current Assets
Plant & Equipment
Accumulated Depreciation
Net Fixed Assests
Total Assets
Liabilities and Owner's Equity
Accounts

Elvis Products International
Statement of Cash Flows
For the Year Ended Dec. 31,2014 ($ in 000's)
Cash Flows from Operations
Net Income
44.22
Depreciation Expense
20.00
Change in Accounts Receivable
-50.80
Change in Inventories
-120.80
Change in Accounts

Question 1
1 out of 1 points
Tiffany just purchased a new house costing $113,000. Houses in the area
are appreciating at the rate of 4.50% per year .If this rate holds steady for
4 years, what will the house be worth assuming that this 4.50% rate is
compo

Elvis Products International
Statement of Cash Flows
For the Year Ended Dec. 31,2014 ($ in 000's)
Cash Flows from Operations
Net Income
44.22
Depreciation Expense
20.00
Change in Accounts Receivable
-50.80
Change in Inventories
-120.80
Change in Accounts

Elvis Products International
Common-size Statement fo Cash Flows
For the Year Ended Dec. 31,2014
Cash Flows from Operations
% of Sales
Net Income
1.15%
Depreciation Expense
0.52%
Change in Accounts Receivable
-1.32%
Change in Inventories
-3.14%
Change in

Mike Owjai Manufacturing
Statement of Cash Flows
For the Year Ended December 31, 2014
Cash Flows from Operations
Net Income
$
46,751
Depreciation Expense
63,000
Change in Marketable Securities
13,924
Change in Accounts Receivable
(36,000)
Change in Invent

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%
charged on the unpaid balance and interest cal

Annuities Applied Practice: Use excel functions and cell references to solve.
Include your name on your spreadsheet.
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