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

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

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