# Math

## Sheet1

Determine whether to invest, given your current cash flows.

.

TRUE FALSE

0

TRUE FALSE

0

TRUE FALSE

0

TRUE FALSE

0

TRUE FALSE

0

TRUE FALSE

0

TRUE FALSE

0

TRUE FALSE

0

TRUE FALSE

0

0

ERROR:#REF!
ERROR:#REF!

SUITABLE ? TYPE OF

Yes or No INVESTMENT JUSTIFICATION

ERROR:#REF!
ERROR:#REF!
ERROR:#REF!

SUITABLE ? TYPE OF

Financial Goals Yes or No INVESTMENT JUSTIFICATION
ERROR:#REF!
ERROR:#REF!
ERROR:#REF!

## Sheet3

#

1

MyBriefcaseFlashdrive

 Sheet 1 of 7 To Save Your Documents: Always back up your files!

&L&F

2

>

#2

Pareto Background

0

, Italian economist Vilfredo Pareto created a mathematical formula to describe the unequal distribution of wealth in his country, observing that twenty percent of the people owned eighty percent of the wealth. In the late

0s, Dr. Joseph M. Juran inaccurately attributed the

0/

Rule to Pareto, calling it Pareto’s Principle. While it may be misnamed, Pareto’s Principle or Pareto’s Law as it is sometimes called, can be a very effective tool to help you manage effectively.

pertise. Quality Management pioneer, Dr. Joseph Juran, working in the US in the 19

0s and 40s recognized a universal principle he called the “vital few and trivial many” and reduced it to writing. In an early work, a lack of precision on Juran’s part made it appear that he was applying Pareto’s observations about economics to a broader body of work. The name Pareto’s Principle stuck, probably because it sounded better than Juran’s Principle.

As a result, Dr. Juran’s observation of the “vital few and trivial many”, the principle that 20 percent of something always are responsible for 80 percent of the results, became known as Pareto’s Principle or the 80/20 Rule.

&L&F

## #3 Illustration

Illustration

– Raw Data

Total

s #1, #2, etc.

or \$*

23 0.46

0

= .46, etc.

14

7

4

2

50

Total 50 1.00
Failure Categories (or \$ spent Frivolously)

Relative Cumulative Frequency

Baggage Delay 23 0.46
Poor Cabin Service 14 0.74
Missed Connection 7 0.88
Lost Baggage 4 0.96
Ticketing Error 2 1.00
 Worksheet 3 of 7 Note: Sheet 1 includes directions for Excel 2007. Table 1 Failure Categories or \$ Spent Frivolously Defect #1 Defect #2 … Defect # 7 Total Day #1 Day #2 Day 14 Note: If privacy is a concern, please label them as Item Note: Steps are directional for Apples and Excel 2007. Sheet 3 gives steps for Excel 2007 Note: Feel free to start on any day of the week. Table 2 – Summary Data Failure Categories (or \$ spent Frivolously) Frequency Relative Frequency Cumulative Frequency Relative Cumulative Frequency Baggage Delay 23 0.46 e.g., Relative Frequency = 23/ 5 Poor Cabin Service 0.28 37 0.74 e.g., Cumulative Frequency = 23+14 = 37, etc. Missed Connection 0.14 44 0.88 e.g., Relative Cumulative Frequency = .46+.28+.14 = .88, etc. Lost Baggage 0.08 48 0.96 grav (`) control Ticketing Error 0.04 1.00 * Remember to sort high to low ** Your study should have 7 categories. Table 3 – Input Data to Excel Frequency or \$ ** Note that Table label and Total are excluded. Note that the first 2 categories have RCF closest to .80. Pareto Chart Note: To continue with the assignment, please continue to Page 2, Project Description. Pareto Statement: Based on the 80/20 rule, ~ 80% of the defects are represented by 2 of the 5 categories. Note: There will be 7 defect categories in your study. The study results will indicate the number of categories out of 7 that represent approximately 80% of your defects. Note 1: In the real world, there are time and cost impacts. Category #1 is not necessarily worked first. In a related analysis, categories may be weighted by their value and then re-analyzed. Note 2: For this study, you data may be more uniformly distributed, With only 7/14 days, your data may not fit the Pareto; that is OK for this assignment.

&L
&L &F&R&D

#3Illustration

&A
Page &P
Problem Types
Frequency
Decimal
Pareto Analysis on Travel Problems

## #4 Project Description

to avoid losing points.

s – Please specify.

&L
&L &F&R&D

## #5 Detailed Steps

Frequency

Baggage Delay 23 0.46
Poor Cabin Service 14 0.74
Missed Connection 7 0.88
Lost Baggage 4 0.96
Ticketing Error 2 1.00

axis (Problem Types)

Always backup your data. See steps on adding a briefcase on MyRutgers account.
 Worksheet 5 of 7 Directions for Excel 2007 and 20 10 Error Category Rel. Cum. Freq. Steps: Set up Landscape Layout. Step 1: Select all data in above table. Include labels and titles Step 2: From ribbon, insert a line chart with markers Step 3: Right click on “Relative Cumulative Frequency” line on chart Step 4: In “Series” options, select “Secondary Axis” Step 5: Right click on “Frequency” line on chart Step 6: to Column Step 7: For labeling the title, x and y axes: Highlight Chart; then click on Step 8: Under “Chart Layouts”, you are given the option for labels on the axes and the title for the chart. Step 9: In SAVE the Pareto template to use again! Step 10: Always backup your data. See steps on adding a briefcase on MyRutgers account. Directions for Excel 2003 Columns A, B, and C of Table 3 are the input data set, sorted high to low. To produce a Pareto analysis, select the three columns of Table 3 (i.e., Error Category, Frequency and Relative Cumulative Frequency). Do not select the column headings. Click on Chart Wizard (bar chart icon). Step 1 of 4 – Choose Custom Types Cursor down until you see “Line-Columns on 2 Axes” Click on Next Step 2 of 4 – Click on Next Step 3 of 4 – Label the title (“Your Name’s” Pareto Chart) Label the X Label the first Y axis (Frequency) Label the second Y axis (Decimal) Step 4 of 4 – Choose the option to place the chart as an object with the raw data Save with a filename (“Your Name’s” Pareto Chart) Via Page Setup, select Landscape or Portrait view; insure that no material runs onto another page. MAC Steps for the MAC are posted Folder #3 Assignment Related Documents under Resources on Sakai. SQC Any software can be used.

&L&F

#5Detailed Steps

Baggage Delay Baggage Delay
Poor Cabin Service Poor Cabin Service
Missed Connection Missed Connection
Lost Baggage Lost Baggage
Ticketing Error Ticketing Error

Decimal
Frequency
Rel. Cum. Freq.
Categories
Frequency
23
0.46
14
0.74
7
0.88
4
0.96
2
1

## #6 Rubric

Rubric

Maximum

:

0 Points

Item Points Lost

1

Table 1

2

X

3

are calculated.

4

X

5 Incorrect X Correct

6

X

7

X

8

X

9

x

10

Incorrect X Correct

0 Points 2 Points 4 Points Item Points Lost

14 Incorrect X Correct

Incorrect X Correct

Incorrect X Correct

Incorrect X Correct

Incorrect X Correct

19

0 Points

2 Points Other Points Lost

19 Incorrect X Correct

20 Incorrect X Correct

No Punctuation Errors Punctuation Errors

0 Points 4 Points

Points Lost

23

Correct

0 Points

8 Points

Points Lost

TBD TBD

 Worksheet 6 of 7 Course Number: Last (Family) Name: Directions: Staple the rubric as Page 1 of the paper document. On-Line version is to be posted on Sakai at least 0.5 hour before class starts. Paper version is to be submitted at the start of the class’s deadline. Course Section: First (Given) Name: 10 0 Points Total Points Earned: Total Points Lost 2 Points 4 Points Either excludes totals or includes 1 total Includes only two totals Includes row, column and grand totals Does not sort frequencies high to low Sorts frequencies high to low Tables 2 and 3: Appropriate data sorted high to low. No averages are provided. Only the row or the column average is provided. Row and column averages provided. Averages Incorrect Correct Tables 2: Totals must be the same: either .99, 1.00 or 1.01 All 3 tables are provided and are in order. (Tables 1, 2, and 3) 2+ tables with column width issues 1 table with a column width issue All tables have sufficient Column Widths. 2+ tables with row height issues 1 table with a row height issue All tables have sufficient Row Heights. 2+ columns with non-centered data 1 column with uncentered data For all tables: Column headings are centered over columns. 2+ columns with unequal decimal places 1 column with unequal decimal places For all tables: Insure an equal number of decimal places within a column. Included fewer than 7 categories Includes 7 categories Included 7 categories 7 Categories are required. 11 Print Preview: No tables split between pages 12 Excludes more than 1 label Excludes 1 label Includes title, labels for all axes and for defect categories Pareto Chart: Includes title, labels for all axes and for defect categories (Title = Pareto Chart of Your Name) 13 3+ errors 2 errors 1 error Overlapping Defect Category Labels and/or Legend overlapping Chart Descending Bars, with No Total Plotted 15 Relative Cumulative Frequency Line Curve Ends at 1, with the legend included. 16 Relative Cumulative Frequency Line progressively increases. 17 The Number of Series = 2. 18 Print Preview: Chart not split between pages. Excluded Observations Included 1 observation Included 2 observations Post 2 Observations: 1 about What You Saw/Learned about Yourself during the Process and 1 on how you would reduce your defects/spending (1 paragraph each.) 1 Point Includes copy of Rubric, stapled as Page 1 of paper submission. No Handwritten Material/Extraneous Materials (except name and class number) 21 > 4 Spelling Errors 1-3 Spelling Errors No Spelling Errors Spell Check 22 > 4 Punctuation Errors 1-3 No Punctuation Errors 8 Points Pareto Statement (place below Pareto Chart) Missing Incorrect / inaccurate Included Pareto Statement “x of the 7 defect categories reflect approximately 80% of the defects.” < ========== > Miscellaneous 24 TBD Miscellaneous: Proof Reading, Grammar, Grids, etc. Penalty: 10% for every class that the project is late.

&R
&L &R&F

## #7 Project Submission

Last (Family) Name: First (Given) Name:
Averages
#1 #2 #3 #4 #5 #6 #7

Total

Total
Averages

Table 2 – Summary Data
Failure Categories (or \$ spent Frivolously)

Relative Frequency Cumulative Frequency Relative Cumulative Frequency
Total

* Remember to sort high to low

** Your study should have 7 categories.
Table 3 – Input Data to Excel
Failure Categories (or \$ spent Frivolously) Frequency
or \$ Relative Cumulative Frequency

Pareto Statement:
 Worksheet 7 of 7 Note: Please check the Rubric to avoid losing points. Note: More than 1 page can be used for the submission. Note: Option 1 is tracking the occurrence (frequency) of the failures; Option 2 is tracking \$. Data Collection Table 1 Date Estimated Dollars (\$) Spent Category 1 Category 2 Category 3 Category 4 Category 5 Category 6 Category 7 Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 Day 11 Day 12 Day 13 Day 14 Note: Only 7 days is needed for Winter/Summer Sessions. Frequency or \$* Notes: The Total in Table 1 should equal the Total in Table 2. If Table 1 has dollars, then Tables 2 and 3 should have dollars. If Table 1 has counts, then Tables 2 and 3 should have counts. Observation 1: Observation 2: Observations should be different from the Pareto Statement. Please use the rubric as a checklist to avoid losing points. Pareto Chart Here:

&L
&L &F&R&D

&L&F

## Sheet 8

3

&L&F

A Step by Step Procedure to Add a Briefcase to a my.rutgers.edu site

In order to save documents that are accessible from any computer, please consider using the Briefcase option in

my.rutgers.edu

2- Click on the tab where you want the briefcase located.

3- From the tab, look all the way to the far right, in grey, where it says more options; Click this tab.

4- A screen that is a map of each tab comes up; Be sure to click the tab where you want the briefcase located

again; Look at the map and decide where you want the briefcase. Then click the “add channel” button above the

location you want the briefcase.

5 – In the next screen, there will be a #1 and a drop down menu; Select web tools and press “go”.

6 – A #2 will be added, with some choices; Click on the briefcase name and press #3; Then add channel below it in

that screen.

7 – The briefcase has been added. If you look at the location you chose, then you will see an actual briefcase that

you can open. Test it out by clicking it to open. At this point, you can either create a folder for a subject or directly

upload a document from your hard drive, flashdrive, etc. and then upload to briefcase. It will now be accessible on

any computer.

Note: At the more options site, you can rearrange the

components of your Rutgers’ site around to customize your site.

2

>Sheet

1

Name :

,000 to invest. You will learn how to monitor your stock portfolio and measure your investment performance. You will also learn about the factors that affect a stock’s performance over time. You can also access a word file from our book’s companion website at www.pearsonhighered.com/madura. You can retrieve the file and same it on your computer, so that you can make updates to the file as you complete the project.

stocks from different industries. Each stock has a ticker symbol. For example, the ticker symbol of Microsoft is MSFT. Insert the ticker symbol of the stock you select in the box that says “Get quotes”. You will see the stock price quoted, along with other financial information. Notice that the quarterly dividend is listed within the financial details, if the stock pays a dividend. The dividend quoted on the Google finance site reflects the dividend provided per quarter.

1

2

3

\$ \$ \$

\$ \$ \$

\$ \$ \$

\$ \$ \$

\$ \$ \$

\$ \$ \$

10

\$ \$ \$

## Sheet3

2

2

2

2

2

2

2

1

2

1

1

2

4

2

Chapters 11, 14 and 16 (Submit ONLY the answer sheet)

Problems

Point

Chapter 11: Auto and Homeowner’s Insurance

CH11.1. Car Accident. What steps should you take if you are in a car accident? (Mention 5 instances)

5

Chapter 14: Investing Fundamentals

CH14.1.a. Return on Stock. Joel purchased 100 shares of stock for \$35 per share. During the year, he received dividend checks amounting to \$160. Joel recently sold the stock for \$42 per share. What was Joel’s return on the stock?

2

CH14.1.b. Capital Gains Tax. Joel is in a 25 percent tax bracket. What amount of taxes will he pay on his capital gain if he held the stock for less than a year?

CH14.1.c. Capital Gains Tax. How much would Joel pay for tax if he held the stock for more than a year, assuming he sold it for the same amount? (Long term capital gain)

CH14.1.d. Capital Gains Tax. How much would Joel save in taxes if he held the stock for more than a year, assuming he sold it for the same amount? (Savings)

CH14.2. Value of Investment. Tammy has \$5,500 that she wants to invest in stock. She believes she can earn a 11 percent annual return. What would be the value of Tammy’s investment in 13 years if she is able to achieve her goal?

CH14.3. Value of Investment. Dawn decides to invest \$4,000 each year in stock at the end of each of the next six years. She believes she can earn a 9 percent return over that time period. How much will Dawn’s investment be worth at the end of six years?

CH14.4. Value of Investment. Bob purchased a dot-com stock, which was heavily advertised on the Internet for \$35 per share shortly after the stock’s IPO. Over the next three years, the stock price declined by 17 percent each year. What is the company’s stock price after three years?

CH14.5.a. Value of Investment. Floyd wants to invest the \$17,000 he received from his grandfather’s estate. He wants to use the money to finance his education when he pursues his doctorate in five years. What amount will he have in five years if he earns a 8 percent return?

CH14.5.b. Value of Investment. From CH14.5.a, if he receives a 11 percent return?

1

CH14.5.c. Value of Investment. From CH14.5.a, if he receives a 13 percent return?

CH14.6.a. Value of Investment. Morris will start investing \$3,500 a year in stocks. He feels he can average a 10 percent return. If he follows this plan, how much will he accumulate in 4 years?

CH14.6.b. Value of Investment. From CH14.6.a, how much will he accumulate in 8 years?

CH14.6.c. Value of Investment. From CH14.6.a, how much will he accumulate in 9 years?

CH14.7. Capital Loss. Charles just sold 500 shares of stock A for \$15,000. In addition, he just sold 650 shares of stock A for \$6,500. Charles had paid \$20 per share for all his shares of stock A. What amount of loss will he have, assuming both sales were on stocks held for more than one year?

Chapter 16: Investing in Bonds

CH16.1. Tax Consequences. Bonnie paid \$9,500 for corporate bonds that have a par value of \$12,000 and a coupon rate of 9 percent, payable annually. Bonnie received her first interest payment after holding the bonds for 12 months and then sold the bonds for \$9,800. If Bonnie is in a 35 percent marginal tax bracket for federal income tax purposes, what are the tax consequences of her ownership and sale of the bonds?

4

CH16.2. Tax Consequences. Katie paid \$9,600 for a Ginnie Mae bond with a par value of \$10,000 and a coupon rate of 8.5 percent. Two years later, after having received the annual interest payments on the bond, Katie sold the bond for \$9,900. What are her total tax consequences if she is in a 25 percent marginal tax bracket? (Hint: Interest: Ordinary income tax & Capital gain: Long-term tax)

CH16.3 Risk Premium. Sandy has a choice between purchasing \$5,000 in Treasury bonds paying 6 percent interest and purchasing \$5,000 in BBrated corporate bonds with a coupon rate of 9.2 percent. What is the risk premium on the BBrated corporate bonds?

5

 Obtain Free Copy of Your Credit Report Create and enclose your own credit monitoring service by getting a free copy of your credit report from AnnualCreditReport.com, the only authorized site under federal law. Submit either page 1 or an e-mail confirmation of the report, with no personal information (i.e., no Social Security Number, no personal data, etc.). If you do not have credit history or the system cannot process your credit report, enclose the error message.
 Life Expectancy Project Fill out the form and answer the following question on the form. What can you do to try to increase your life expectancy based on the 3 biggest negative factors that you have going for you? 6

Take Home Exam #3: Chapters 11, 14 and 16 Page 4 of 4

Chapters 11, 14 and 16 (Submit ONLY the answer sheet)

Point

Chapter 11: Auto and Homeowner’s Insurance

5

Chapter 14: Investing Fundamentals

2

2

2

2

2

2

2

2

1

1

2

1

1

2

Chapter 16: Investing in Bonds

4

4

2

 All work must to be submitted on-line one half hour before class on the assignment due dates. Merely posting final answers is insufficient. Last/Family Name: First/Given Name: RU ID: Signature: Formulae and Solutions Final Answer DED Grade CH11.1. CH14.1.a. CH14.1.b. CH14.1.c. CH14.1.d. CH14.2. CH14.3. CH14.4. CH14.5.a. CH14.5.b. CH14.5.c. CH14.6.a. CH14.6.b. CH14.6.c. CH14.7. CH16.1. CH16.2. CH16.3. Point Deducted 50 Score Earned for #3

Gary Grandview – A continuing Case – Part 4

Gary’s company updates its benefit package annually. During this open enrollment time, employees have the option to upgrade or make changes to their insurance and benefit coverage. To help the employees understand the programs being offered, the company has brought in several insurance consultants to explain the different policies and how each policy could benefit the employees. While listening to the consultants, Gary decides to look into his auto and life insurance policies.

Gary mentions that he is generally happy with the HMO insurance plan he has through the technology company where he works. However, Gary also mentions that he does not particularly like to see his primary care physician each time he requires a consultation with a specialist. He tells you that his company also offers a PPO, but he did not choose that plan because he knows so little about PPOs.

Gary becomes concerned about his auto insurance after hearing a co-worker recently had his car totaled by an uninsured motorist. Gary has not looked at his auto insurance policy since he purchased it two years ago. Gary discovers that selecting insurance coverage is harder than he originally anticipated.

Gary’s current policy covers just the basics at the minimum required levels allowed by law. There are so many types of insurance that he becomes confused and needs some advice. Recall that Gary is 25 years old, has a driving record that contains several speeding tickets, a couple of parking tickets and two accidents (one of which he caused). Gary realizes that adding coverage will increase the cost of his auto insurance. Therefore, he is thinking about switching auto insurance companies to a less expensive carrier. The agent notices that Gary commutes 17 miles to work. The agent mentions in passing that Gary could save \$200 in insurance payments if his commute to work was 12 miles or less. This gets Gary to thinking about saving in other areas. Less mileage means less gas; he could save a tank of gas per month if he moved closer to where he works. Moving is a lot of work, and he likes where he lives now.

When you ask Gary whether he has renter’s insurance, it is obvious that he does not know what renter’s insurance is.

Gary is trying to decide between term life insurance, universal life and whole life insurance. He likes whole life insurance, and he believes that the loan feature on that policy will give him an option for meeting his liquidity needs.

Gary Grandview Part 4 Reading Segment Revised 3.6.2013 – SL_ML_SL2

2

>BB-

4 Name:

Grandview—A Continuing Case

-4. Continue to assume the role of Gary’s advisor and provide your answers in a business like style and ton

(*Excel Toolbar, Home Tab, Alignment section)

Drag the bottom line of the number row (far left column) down, or

Insert a row while inside the yellow text box.

e.

1

4
2

a)

4

b)

4

4

factors.

4

2
2

a)

4

b)

2

3

a)

2

b)

2

c)

2

d)

2

2

4

a)

2

b)

2

c)

2

d)

2

e)

2

2

0

## Sheet3

InsertPicture

Gary Grandview —A Continuing Case

This is a continuing 6 part practical application of the material learned in class.

Each part of the Continuing Case study has a reading assignment document and a homework document.

Utilize the all information provided to you. Read the Case and answer the questions in the coordinating Gary Grandview Excel file.

As you progress through the sequential parts, the financial information will be updated.

Analyze the material and give Gary advice from the perspective as his financial analyst. Give Gary advice on items he may or might not have previously considered.

Answers are to be provided using proper grammar and in business language tone.

Gary Grandview — Part 1

Gary is a 25 year old single male who graduated from college a few years ago. Gary has been working as a computer specialist for an ‘up and coming’ company for the past 3 years. Gary has an active lifestyle. He enjoys going out with friends during the week and getting out of the city at least once per month to relax and go camping. Gary’s favorite camping spot is on the shores of Lake Oswego approximately 40 miles from where he lives.

Gary received a raise last year and now earns a gross income of \$48,000 per year. Gary’s tax return revealed that he paid \$3,672.00 in FDIC payroll taxes [\$696.00 in Medicare and \$2976.00 in Social Security] and contributed \$4,680.00 toward his medical benefits. Gary has college loan payments of \$320.00 per month on \$32,000 student loans (Current balance 16,880.00). Gary’s receives his paychecks by automatic deposit and does not always pay attention to the balance in his checking account.

Gary is renting a 2 bedroom apartment in a building that the owner is considering converting into Condominium Complex. Two years ago Gary purchased a new red 4 wheel drive pick-up for \$24,300 (\$ 18,500 Blue Book value) and his payments are \$358.00 per month. The pickup has a current loan balance of \$18,200.00, and pays \$325.00 per month in auto insurance coverage.

Where Gary currently resides, there is no public transportation available, therefore he commutes to work each day. Traffic is heavy getting into the city therefore the drive to work often takes Gary 35 – 45 minutes. Gary likes his pickup and is impressed that it gets 17 miles to the gallon.

Gary has some decisions to make and comes to you (his new best friend and financial analyst) for some advice. His spending is a little out of control and asks your help in creating a budget he can live with. You discover that Gary has a few other monthly expenses that Gary forgot to mention and need to be included in his monthly budget:

Rent 850.00

Renter’s insurance 50.00

Utilities (gas and electric) 110.00

TV, Internet, & House phone 120.00

Cell phone (personal calls) 225.00

Food (consumed at home) 200.00

Clothes 170.00

Car expenses (gas, maintenance) 254.00

Camping 325.00

Entertainment (dining out, golf, weekend trips) 400.00

Gary is surprised at how much money he is spending on living costs. He admits that when he is short on cash he uses his credit card and has accumulated a balance of \$8,600.00. Gary also admits that sometimes he has a hard making the \$200.00 credit card payments on time.

Gary currently has \$2,110.00 in his checking account and \$490.00 in his savings account. His bank requires automatic deposits to maintain a free checking account. He has household furnishings valued at \$2,700.00, \$2,500.00 in speculative Green Planet Technology Stock and a small ten year \$500.00 municipal bond he received from his mother upon graduation.

Gary has a few concerns he would like you to consider regarding his payments. Gary’s credit card payment, student loan and rent are all due on the first of the month. Gary wants to retire when he is 50. Gary knows he should start investing in a retirement plan; however he feels he cannot afford it even though his employer offers a matching fund up to \$3,600 per year. Gary thinks he should be able to afford to start investing in the retirement fund in 5 years. Gary is confident he will be able to retire as planned if he invests \$300 per month.

2

>Part

1

Analytic Problems

Name:

Read the coordinating Word Document on Gary. Assume the role of Gary’s financial advisor. Apply the facts and provide analytical answers. Note: Part 1 should be considered while analyzing Parts 2-6.

Tab, Alignment section)

Drag the bottom line of the number row (far left column) down, or

Insert a row while inside the yellow text box.

Print in Portrait.

e.

1

Flow Statement

Cash Inflows

.00

2

expenses ( gas & maintenance )

\$0.00 2

\$0.00 2

2

Cash

\$0.00 2

Home
Car

\$0.00 2

\$0.00 2

\$0.00 2

\$0.00 2

\$0.00

\$0.00 1

\$0.00 2

a)

2
b)

2

c)

2

1

1

1

2

of an Annuity

Future Value \$0.00 2
6)

Payment per Period
Number of Periods
Interest Rate per year 7.00%
Future Value \$0.00 2

Future Value of an Annuity
Payment per Period
Number of Periods
Interest Rate per year 7.00%
Future Value \$0.00 2

2

a) 2
b) 2
c) 2
a)

2

b)

2

2
Total

0

## Sheet3

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

2

Free

Free

Free

\$1.25

\$1

N/A

N/A

 Hillsboro Bank First National South Trust Bank Sun Coast Bank ATM Charges Home bank Free Other bank 4 free then \$2 per use \$1.25 \$1 .25 Checking Minimum deposit \$100 \$25 \$1 Minimum balance required to avoid fees* N/A \$400 Monthly fees \$6 \$7 \$13 \$2.5 Check-writing charges 12 free, then \$1 per check 7 free, then \$1 per check Unlimited Each check 50 cents

Take Home Exam_1-4-02-14-2013 Page 1 of 5

Point

Chapter 3: Applying Time Value Concepts

2

2

2

2

2

2

2

2

2

2

2

2

Chapter 4: Using Tax Concepts for Planning

2

2

2

2

2

Chapter 5: Banking and Interest Rates

2

2

2

2

2

2

2

2

 Take Home Exam #1: Chapters 3, 4 and 5 (Submit ONLY the answer sheet) All work must to be submitted on-line one half hour before class on the assignment due dates. Merely posting final answers is insufficient. By signing below, I acknowledge that I have read and fully understand the instructions and the Academic Integrity Policy. Last/Family Name: First/Given Name: RU ID: Signature: Formulae and Solutions Final Answer DED Grade CH3.1. CH3.2. CH3.3. CH3.4. CH3.5. CH3.6. CH3.7. CH3.8.a. CH3.8.b. CH3.8.c. CH3.8.d. CH3.9. CH4.1. CH4.2. CH4.3. CH4.4. CH4.5. CH5.1. CH5.2. CH5.3. CH5.4. CH5.5.a. CH5.5.b. CH5.6.a. CH5.6.b. Point Deducted 50 Score Earned #1