The local high school soccer club need to borrow to finance a new soccer field. Repayment of the loan involves payments of $10 000.00 at the end of every 3 months for 8 years. No payments are to be made during the development period of 5 years. If interest is 8% compounded quarterly, how much did the Achievers borrow? a) $162 064.83 b) $234 683.35 c) $157 935.17 d) $175.935.71 e) $320 000.00 .

The local high school soccer club need to borrow to finance a new soccer field. Repayment of the loan involves payments of $10 000.00 at the end of every 3 months for 8 years. No payments are to be made during the development period of 5 years. If interest is 8% compounded quarterly, how much did the Achievers borrow? a) $162 064.83 b) $234 683.35 c) $157 935.17 d) $175.935.71 e) $320 000.00 .

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
11. for the year 2020, company a implemented a strategy of horizontal integration. on this action, they were expecting a 5,000,000 return of investment within a year. now, on the third quarter of the year they started, company a decided to evaluate their strategy. on this situation, what should be the amount writteen within their expected result? a. 414,666 b. 2,500,000 c. 625,000 d. 1,250,000
Based on Exhibit 9-9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round time value factor and final answers to 2 decimal places. What relationship exists between the length of the loan and the monthly payment? How does the mortgage rate affect the monthly payment? Monthly Mortgage Payment a. $123,000, 15-year loan at 6.00 percent. b. $165,000, 30-year loan at 7.50 percent. c. $68,000, 20-year loan at 7.50 percent. d-1. Longer mortgage terms mean a monthly payment. d-2. For increase in mortgage rate monthly payment is required.
Match the following terms to their definitions: valuation, return on investment, discount rate, terminal value 1. The value of an investment at the end of an investment period 2. The return that investors expect to earn for putting their capital at risk 3. The amount of profit made on a given investment 4. An estimate of the economic worth of an asset or business a. Discount rate b. Valuation c. Return on investment d. Terminal value
Kabelo and Hendrik are joint owners of Fitness Gym. They are currently investigating the option of investing in cryotherapy, a cold therapy that may reduce inflammation in tendons or joints. Their investment would provide Fitness Gym members with equipment which may be used to reduce post-exercise recovery times, at an additional cost. The addition of cryotherapy to the gym represents a strategic service for Fitness Gym. Which one of the following statements reflect the importance of capital-investment projects such as the example above. a. The relative magnitude of the amounts involved. b. The short-term nature of capital-investment decisions. c. The operational nature of capital-investment projects. d. The direct effect of the time value of money on capital-investment projects.
The following is a breakdown of supplying and installing a piece of equipment to a project owner, atthe time of contract: EGPCost of equipment 250,000Manpower (installation) 50,000Overhead and profits 70,000i – Calculate the price of supplying and installing the equipmentii – If the supply and installing of the equipment was delayed by the project owner, calculate theescalated price of works based on the FIDIC Red Book 1990 formula given:Updated cost of equipment 270,000 EGPBase price index of manpower 123.2Updated price index of manpower 144.9
Haya International are considering a project that is susceptible to risk. An initial investment of OMR90,000 will be followed by four years each with the following ‘most likely’ cash flows (there is no inflation or tax): OMR OMR Annual Sales 400,000 (volume of 100,000 units multiplied by estimated sales price of OMR 4) Annual Costs Labour 200,000 Materials 40,000 Other 10,000 250,000 (250,000) 150,000 The initial investment consists of OMR80,000 in machines, which have a zero scrap value at the end of the four-year life of the project and OMR10,000 in additional working capital which is recoverable at the end. The discount rate is 10 per cent. Required : Calculate the NPV and show the sensitivity of NPV to changes in the following: Increase in sales price by 10%; Decrease in discount rate by 10%
The Sloan Corporation is trying to choose between the following two mutually exclusive design projects. If the required return is 10 percent, what is the profitability index for each project? What is the NPV for each project? Complete the following analysis. Do not hard code values in your calculations. You must use the built-in excel function to answer this question. Annual Cash Flows I II 0 $ (51,000.00) $ (14,000.00) 1 $ 24,800.00 $ 7,800.00 2 $ 24,800.00 $ 7,800.00 3 $ 24,800.00 $ 7,800.00 Required Return 10% Profitability index (I)_________________ Profitability index(II)_________________ NPV (I) ______________ NPV (II) ______________
Troop Inc. is considering building a factory in India. The estimated cash flows for the project are given below and management consider that a discount rate of 12% reflects the riskiness of the venture. The Indian government has agreed to purchase the factory at the end of three years operation for Rupees 250 million. Year 0 Year 1 Year 2 Year 3 Total cash inflows (Indian rupees (m)) 0 300 500 600 Total cash outflows (Indian rupees (m)) 800 220 230 280 Increase in US cash inflows (m) 0 2 2 2 Forecast exchange rate Rupees /$ 78.7 78.9 80 80.5 Required:a) Calculate the net present value of the project and advise whether Troop Inc should build the factory. b) Describe the factors Troop Inc. should consider when…
Method of Least Squares, Goodness of Fit Deepa Dalal opened a free-standing radiology clinic. She had anticipated that the costs for the radiological tests would be primarily fixed, but she found that costs increased with the number of tests performed. Costs for this service over the past nine months are as follows: Month Radiology Tests Total Cost January 2,800 $133,500 February 2,600 135,060 March 3,100 175,000 April 3,500 170,600 May 3,400 176,900 June 3,700 186,600 July 3,840 174,450 August 4,100 195,510 September 3,450 185,300 Required: 1. Compute the cost formula for radiology services using the method of least squares. If required, round your answers to two decimal places. Y = + X 2. Using the formula computed in Requirement 1, what is the predicted cost of radiology services for October for 3,500 appointments? (Round the answer to the nearest dollar.)
The Ace Steel Mill estimates the demand for steel in millions of tons per year as follows:Millions of Tons Probability10 .1012 .2514 .3016 .2018 .15a. If capacity is set at 18 million tons, how much of a capacity cushion is there?b. What is the probability of idle capacity, and what is the average utilization of the plant at 18 million tons of capacity?c. If it costs $8 million per million tons of lost business and $80 million to build a million tons of capacity, how much capacity should be built to minimize total costs?
A publisher has a fixed cost of $250,000 associated with the production of a college mathematics book. The contribution to profit and fixed cost from the sale of each book is $6.25. (a) Determine the number of books which must be sold in order to break even. (b) What is the expected profit if 50,000 books are sold?