#### Using Excel: Mutual Fund

Excel Mutual Fund Your mutual fund grows from \$1200 to \$1500 in 1 year. a.) What is the annual growth rate (format as % to zero decimal places)? Growth factor (format as number 2 decimal places)? b.) Create a table of values expressing the amount in your fund through year 10 assuming this con...

#### Buying versus Renting

Objective: In this project you will create an Excel workbook consisting of two worksheets. You will then use it to perform various financial calculations and answer the questions below. Specifically, it will be used to examine whether it is better to buy a home or rent, depending on things such as i...

#### Credit Card Excel

Credit Card Project Description: In this problem, you will investigate two credit cards that you can choose to make payment and determine which one is better. Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values. ...

#### BMI worksheet

In this problem, you will calculate Body Mass Index given the inputs of Height and Weight. You will also provide the results as bar, line, and column charts. Use a cell reference or a single formula where appropriate. 2 In cell F9, convert the height in C7:C8 to inches. 3 In cell F12, use the a...

#### Paying Off Credit Card Balances

Assume you have a \$3,500 balance on a credit card with a 14.5% APR. You are only able to make \$150 payments each month and you get an offer for a new credit card which will give you 0% on transferred balances for 6 months and then switch to a 16.7% rate. They will charge you 3% on any balance you ...

#### Dosage Error Calculations

Dosage Error Calculations Last month Hometown Hospital admitted more than the usual number of patients due to a severe streptococcus outbreak in the area. The outbreak was widespread causing hospitalization for men, women, and children of all ages. Unfortunately, there were some major complicatio...

#### Consumer Price Index - All Urban Consumers

This problem uses Consumer Price Index (CPI) data from the U.S. Bureau of Labor Statistics (BLS) from 1913 to 2015. Note the years may be hidden, scroll to go all the way back to 1913. a.) Use the annual CPI values to convert the given cost of an iPhone 6s in 2015\$ into every other years' do...

#### Applications of Conversions

1. You are ordering linoleum for an 18' by 15' kitchen, but when you get to the store the measurements are in square yards, how much should you order? 2. Is the following statement reasonable? (Justify your answer!) The area of a dorm room is 49 m2. 3. A round silo is 60 feet tall and has a ...

#### Determining the Final Price of an Item

(1) Assume that the original price of an item is eventually increased by 25%, and that a 25% discount is applied later. How does the final price compare to the original price? (2) Assume that the original price of an item is eventually discounted by 25%, and that a 25% increase is applied later. ...

#### Water Bottle Tracking Worksheet

In this worksheet, you will calculate the amount of carbon dioxide, or "carbon footprint," emitted by just one stage of a plastic water bottle's life cycle: transportation. You will also perform some other calculations related to bottled water consumption in the United States. Use the answers you c...

#### Population Growth (Calculations & Graph)

Do a spreadsheet on population of animals using the exponential equation: Explain the implications of growth rate for population.Select a positive annual percentage growth rate greater than 0%. Calculate what the future size of the population will be, given the below assumptions: future value r= an...

#### Food-Storage Capacity of a Refrigerator

The electric company in a certain community has instituted a program to get people to save energy: by giving up their old refrigeators, especially those that are sitting in basements and are no longer being used to cool food. The electric company will go out to the home of a resident and pick up a r...

#### Length of Fencing For a Garden

I need detailed help in setting up order of operations and finding answer to the following: A garden is next to a garage. The garden is fenced in, with the garage forming one of the four sides. The garden is 24ft by 20 ft. How may feet of fencing do you need? That is the question as written. N...

#### CPI trend for travel time

What is CPI? Given that the CPI trends for travel time for 2010 and this year are 183.42 and 191.35 respectively, calculate the current value of travel time if it was \$24.50 per hour in 2010. ____(20 points)

#### Calculations with decimals and fractions

Ron read 1/4 of a book on Day 1, 5/8 of the book on Day 2, and finished the book on Day 3. What decimal represents the fraction of the book he finished on day three? I think the answer is 1/8. Please show provide step-by-step instructions to solve this problem. A piece of cloth is 10.5 centime...

#### Supply and Demand with Total Profit

Assuming that a competitive firm has the total cost function: TC = 1q3 - 40q2 + 710q + 1700 and suppose the price of the firm's output (sold in integer units) is \$550 per unit. Use tables (but not calculus) to find a solution and answer what is the total profit at the optimal output level, ...

#### NPV Explanation and Calculation

I would like to have the solution to the following sample problems in EXCEL format so that I can see the formulas used. Thanks 1. A firm that purchases electricity from the local utility for \$300,000 per year is considering installing a steam generator at a cost of \$340,000. The cost of operating...

#### Zero-Coupon Discount Rate

I would like to have the solution to the following sample problems in EXCEL format, so that I can see the formulas used. Thanks. 1. What is the current value of a zero-coupon bond that pays a face value of \$1,000 at maturity in 9 years if the appropriate discount rate is 7%. Please round your ...

#### measuring concepts and tools

Scientific techniques are used to take measurements in standardized ways and to control error and precision. Mathematical techniques are used to recognize relationships among the variables measured and to develop formulas and generalizations based on that real-world data. Complete the f...

#### Adding Fractions with a Calculator

Several calculators are now available that do computations in fractional form as well as in decimal form. Some of these automatically give results in simplest terms. If you have access to such a calculator, discuss how it might be used in teaching fractions and especially fraction computation. If...

#### Calculating the operating income from the function

A catering service has been asked to provide a lunch buffet the next day for 40 people at a set price of \$10.50 per person; no function has been booked for the next two days. The catering service has fixed costs of \$150.00 a day or \$54,750 per operating year, and it operates with a variable cost of...

#### Various Question about Hypothesis Testing

Address Questions 2 on page 1 (see attachment). Questions 4, 7, 12, and 16 on page 2 Questions 9, 10 on page 3 Questions 12, 16, 18, and 36 a-d on page 4 Questions 40, 42, 44 on page 5 Questions 2 a-c, 4 a-d, and 6 a-d on page 6 Questions 8 a-d, 10 a-f, 12 a-c on page 7 Questions 18, 20, and ...

#### Address Investment Questions

1) What is the asset value of an investment company with \$10,000,000 in assets, \$790,000 in current liabilities, and 1,200,000 shares outstanding? 2) If a mutual fund's net asset value is \$23.40 and the fund sells its shares for \$25, what is the load fee as a percentage of the net asset value? 3) ...

#### Analysis of Credit Card Debt

The amount of credit card debt is \$5,270.00 with an average APR of 15.53%. Considering the minimum monthly payment of \$120.00 determine the interest. How long will it take to pay off if only making minimum payments? If graphs or charts are available please include.