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...

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
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.
...

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...

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
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...

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...

1. Carbon Dioxide Emissions 2012
Below is data from the Earth Policy Institute showing the top 10 countries' fossil-fuel carbon dioxide (CO2) emissions during 2012. The bar chart at the right comes from a 2012 CO2 report published by the PBL Netherlands Environmental Assessment Agency.
Open th...

A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Product 1 requires 10 hours of processing time on line 1 and product 2 requires 14 hours of processing on line 1. , On line 2, product 1 requ...

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 ...

(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. ...

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...

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...

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...

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...

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)

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...

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, ...

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...

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 ...

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 present value of a series of payments received each year for 9 years, starting with $300 paid one year from now and the payment growing in each subsequent ...

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...

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...

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...

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) ...

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.

Clean Car Solutions (CCS), a manufacturer of car and two-wheeler engines, has purchased a1000 bearings per week from a local supplier who charges $1 per bearing. Recently during a Trade Exhibition, the CEO of CCS has identified another potential source willing to supply the bearings at $0.95 per bea...