Assignment capital budget excel template

Assignment Help Basic Statistics
Reference no: EM131975426

The Assignment:

Use the "Week 10 Assignment Capital Budget Excel Template" to show your work, answer the following questions:

1:If a physician deposits $24,000 today into a mutual fund that is expected to grow at an annual rate of 8%, what will be the value of this investment:

a. 3 years from now

b. 6 years now

c. 9 years from now

d. 12 years from now

2: The Chief Financial Officer of a hospital needs to determine the present value of$120,000 investment received at the end of year 5. What is the present value if the discount rate is:

a. 3%

b. 6%

c.9%

d.12%

3: The Kadrie's dental group purchased a new diagnostic machine for their office for$1,200,000. The expected cash flows for each year of the five year period is

$140,000, $175,000, $199,000, $218,000, and $245,000 for the five years. What is the internal rate of return or the IRR for the project?

4: Determine the Net Present Value for Problem 3 with an interest rate of 10%. Do you proceed or not with the project?

5: Determine the Payback Period for Problem 3.

Reference no: EM131975426

Questions Cloud

Requiring any additional fixed assets : The firm is currently operating at 88% of capacity. How high can the firm's sales go without requiring any additional fixed assets?
What are the traditional measures of firm profitability : What are the traditional measures of firm profitability? What are the traditional measurements of a risky firm?
What is the benefit for the furniture division : Suppose that the two divisions agree on a transfer price of $35. What is the benefit for the Furniture Division? For the Motel Division
How much gross income must she report for federal income tax : If Marsh distributes $750,000 to Mary on December 31, how much gross income must she report for Federal income tax purposes?
Assignment capital budget excel template : Use the "Week 10 Assignment Capital Budget Excel Template" to show your work, answer the following questions:
Calculate the amount of calories : Calculate the amount of calories, protein and fluid from a rate - calculate cans from pt estimated needs
Determine the effective cost of borrowing in dollars : On September 30, 2015, Ericson Company negotiated. Determine the effective cost of borrowing in dollars in each of the three years 2015, 2016, and 2017.
What was overhead applied to the job during july : On July 1, Job 46 had a beginning balance of $710. During July, prime costs added to the job totaled $610. What was overhead applied to the job during July
What is the depreciation expense for the year ended december : On September 1, a company purchased a vehicle for $23,000 with a residual value of $3,000. What is the depreciation expense for the year ended December 31?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Test the effects of combined estrogen and progestin

Breast Cancer Risk Stops Hormone Replacement Therapy Study On July 17, 2002, the Journal of the American Medical Association published the results of a study.

  What is the probability that the mean test score is greater

In a recent year grade 8 Washington State public school students taking a mathematics assessment test had a mean score of 276.1 with a standard deviation of 34.4. Possible test scores could range from 0 to 500. Assume that the scores are normally dis..

  Number of times the number

A balanced die is tossed (independently) 21 times and let Xj be the number of times the number j appears,j = 1, .. ., 6.

  Using kitchen as population 1 and master bedroom as

the national association of home builders provided data on the cost of the two most popular home remodeling projects.

  What are the center line and control limits for given chart

The sample standard deviation s for each hour's sample is plotted on an s control chart. What are the center line and control limits for this chart?

  What is the probability that 11 or fewer are convicted

In New Mexico, about 70% of drivers who are arrested for driving while intoxicated (DWI) are convicted .

  A machine has 15 identical componenets which function

a machine has 15 identical componenets which function independently. the probability that a component will fail is

  Construct a 95 confidence interval to estimate the

suppose the following data are selected randomly from a population of normally distributed values.44 51 43 48 45 57 54

  Database of customers and sales information

For each customer, it records name, ID number, region of the country (1 = East, 2 = South, 3 = Midwest, 4 = West), date of last purchase, amount of purchase, and item purchased.

  Calculating the margin of error

Constructing a 95% confidence interval for the true length of time for all pepper seeds to germinate you must calculate the margin of error. The margin of error in this case is 0.60.

  How would you define a fair game

How would you define a fair game? Does the number of times the game is played affect your view of whether the game is fair or not? Explain.

  Formula for the probability curve

a. Write the formula for the probability curve of x. b. Graph the probability curve of x.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd