ch04_spreadsheet_activity_instructions_4.2

Current Attempt in Progress Your answer is partially correct. Vaughn Inc. owns and operates a number of hardware stores in the New England region. Recently, the company has decided to locate another store in a rapidly growing area of Maryland. The company is trying to decide whether to purchase or lease the building and related facilities. Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $1,865,700. An immediate down payment of $415,500 is required, and the remaining $1,450,200 would be paid off over 5 years at $369,000 per year (including interest payments made at end of year). The property is expected to have a useful life of 12 years, and then it will be sold for $508,900. As the owner of the property, the company will have the following out-of-pocket expenses each period. Property taxes (to be paid at the end of each year) Insurance (to be paid at the beginning of each year) Other (primarily maintenance which…

Investment Proposals for Orio Coffee House Daniel Jackson, CEO of OCH, has approached you to work on 2 investment proposals that the company is considering: 1. Buying coffee roaster plant in Mexico. 2. The Reconstruction of coffee shops to add the selling of yogurt. Mr. Daniel reminds you to consider only relevant expense and income. “Relevant costs have to be occurring in the future,”He said. “And have to be unique from the status quo. For example, if we choose to buy the roaster plant, it is only the incremental revenue and costs related to the purchase that should be considered. We also need to take into account the opportunity cost associated with the alternatives.” More details on both of investment proposal is written below. Mr. Daniel wants you to recommend after evaluation, if OCH should invest in one, both, or none of the investment proposals. Required Return Mr. Daniel wants you to use 7% as the discount rate (i.e., the required return). First Proposal of Investment in…

#15 Carni’s boss stated that after reviewing first quarter earnings, the company decided to invest in only one store in the city.  After evaluating the performance of the store, the company will determine if it wants to increase its presence in the area. a) If you were Carni, what method of evaluation would you use to recommend a site for a new video store? b) Explain how you would determine which site to invest in.

The owner of a small printing company is considering the purchase of additional printing equipment to expand her business. If the owner expands the business and sales are high, projected profits (minus the cost of the equipment) should be $90,000; if sales are low, projected profits should be $40,000. If the equipment is not purchased, projected profits should be $70,000 if sales are high and $50,000 if sales are low. Consider Decision Tree Analysis   If the owner is optimistic about the company's future sales, should the company expand by purchasing the equipment? Is the owner's optimism or pessimism about sales the only factor that may impact the company's profits?

The owner of a small printing company is considering the purchase of additional printing equipment to expand her business. If the owner expands the business and sales are high, projected profits (minus the cost of the equipment) should be $90,000; if sales are low, projected profits should be $40,000. If the equipment is not purchased, projected profits should be $70,000 if sales are high and $50,000 if sales are low. Consider Decision Tree Analysis Are there options other than the purchase of additional equipment that should be considered in making the decision to expand the business? The equipment to be purchased is known in the industry to have a useful life of five years. How might this impact the printing company?

Suisan Fish Company must decide whether to build a small or a large warehouse at a new location, Kona. Demand at Kona can be either low or high, with probabilities estimated to be 0.4 and 0.6, respectively. If a small warehouse is built, and demand is high, the fish manager may choose to maintain the current size or to expand. The net present value of profits is $220,000 if the company chooses not to expand. However, if the firm chooses to expand, there is a 50% chance that the net present value of the returns will be $330,000 and a 50% chance the estimated net present value of profits will be $220,000. If a small warehouse is built and demand is low, there is no reason to expand and the net present value of the profits is $210,000. However, if a large warehouse is built and the demand turns out to be low, the choice is to do nothing with a net present value of $25,000 or to stimulate demand through local advertising. The response to advertising can be either modest with a probability…

Please look at image for the question, answer in excel and show steps please.

A refinisher of antiques named Constance has been so successful with her small business that she is planning to expand her shop. She is going to start enlarging her shop by purchasing the following equipment.(a) What would be the net cost to Constance to obtain this equipment? Assume that she can trade the old equipment in for 15% of its original cost. Assume there has been no inflation in equipment prices. (b) Suggest a green engineering approach to constance for disposing of the solvents and lacquers used in her business.

HomeGrown Company is a chain of grocery stores that are similar to indoor farmer's markets, providing fresh, local produce, meats, and dairy products to consumers in urban areas. HomeGrown is considering opening several stores in a new city, and has proposals from three contractors (Alpha, Beta, and Gamma companies) who would like to provide buildings for the new stores. The amount of expected revenue from the stores will depend on the design of the contractor. For example, if HomeGrown decides on a more open floor plan, with less shelf space for products, revenue would be lower overall. However, if HomeGrown decides on a very crowded floor plan, it may lose customers who appreciate a more open feel. As the project manager for HomeGrown, you are responsible for deciding which if any of the proposals to accept. HomeGrown's minimum acceptable rate of return is 20%. You receive the following data from the three contractors: Proposal Type of Floor Plan Investment if Selected…

HomeGrown Company is a chain of grocery stores that are similar to indoor farmer's markets, providing fresh, local produce, meats, and dairy products to consumers in urban areas. HomeGrown is considering opening several stores in a new city, and has proposals from three contractors (Alpha, Beta, and Gamma companies) who would like to provide buildings for the new stores. The amount of expected revenue from the stores will depend on the design of the contractor. For example, if HomeGrown decides on a more open floor plan, with less shelf space for products, revenue would be lower overall. However, if HomeGrown decides on a very crowded floor plan, it may lose customers who appreciate a more open feel. As the project manager for HomeGrown, you are responsible for deciding which if any of the proposals to accept. HomeGrown's minimum acceptable rate of return is 20%. You receive the following data from the three contractors: Proposal Type of Floor Plan Initial Cost if Selected…

HomeGrown Company is a chain of grocery stores that are similar to indoor farmer's markets, providing fresh, local produce, meats, and dairy products to consumers in urban areas. HomeGrown is considering opening several stores in a new city, and has proposals from three contractors (Alpha, Beta, and Gamma companies) who would like to provide buildings for the new stores. The amount of expected revenue from the stores will depend on the design of the contractor. For example, if HomeGrown decides on a more open floor plan, with less shelf space for products, revenue would be lower overall. However, if HomeGrown decides on a very crowded floor plan, it may lose customers who appreciate a more open feel. As the project manager for HomeGrown, you are responsible for deciding which if any of the proposals to accept. HomeGrown's minimum acceptable rate of return is 20%. You receive the following data from the three contractors: Proposal Type of Floor Plan Initial Cost if Selected…

HomeGrown Company is a chain of grocery stores that are similar to indoor farmer's markets, providing fresh, local produce, meats, and dairy products to consumers in urban areas. HomeGrown is considering opening several stores in a new city, and has proposals from three contractors (Alpha, Beta, and Gamma companies) who would like to provide buildings for the new stores. The amount of expected revenue from the stores will depend on the design of the contractor. For example, if HomeGrown decides on a more open floor plan, with less shelf space for products, revenue would be lower overall. However, if HomeGrown decides on a very crowded floor plan, it may lose customers who appreciate a more open feel. As the project manager for HomeGrown, you are responsible for deciding which if any of the proposals to accept. HomeGrown's minimum acceptable rate of return is 20%. You receive the following data from the three contractors: Proposal Type of Floor Plan Initial Cost if Selected…

Note:- • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. • Answer completely. • You will get up vote for sure.

2. You are thinking about starting a restaurant franchise in Irvine, California. You are considering two choices – either a P.F. Chang’s or a Dairy Queen. Unfortunately, you only have an opportunity to build one or the other. The details are the following:    P.F. Chang’s: The franchise fee and cost of the building are $1,000,000. After careful calculation, you believe the restaurant will generate $150,000 a year in positive cash flow for the next 20 years at which point the franchise rights expire and the building is worthless (ie. There’s no extra money at the end). Discount rate is 10%.    Dairy Queen: The franchise fee and cost of the building are $500,000. After careful calculation, you believe the restaurant will generate $80,000 a year in positive cash flow for the next 20 years at which point the franchise rights expire and the building is worthless (ie. There’s no extra money at the end). Discount rate is 10%.   a) What are the two projects’ IRRs and which franchise would you…

Please solve all parts i will  definitely like

The owner of a small printing company is considering the purchase of additional printing equipment to expand her business. If the owner expands the business and sales are high, projected profits (minus the cost of the equipment) should be $90,000; if sales are low, projected profits should be $40,000. If the equipment is not purchased, projected profits should be $70,000 if sales are high and $50,000 if sales are low.   Are there options other than the purchase of additional equipment that should be considered in making the decision to expand the business? If the owner is optimistic about the company's future sales, should the company expand by purchasing the equipment? Is the owner's optimism or pessimism about sales the only factor that may impact the company's profits? The equipment to be purchased is known in the industry to have a useful life of five years. How might this impact the printing company?

The Monty Inc., a manufacturer of low-sugar, low-sodium, low-cholesterol TV dinners, would like to increase its market share in the Sunbelt. In order to do so, Monty has decided to locate a new factory in the Panama City area. Montyy depending upon which is more advantageous. The site location committee has narrowed down the three very similar buildings that will meet their needs. Building A: Purchase for a cash price of $613,700, useful life 27 years. Building B: Lease for 27 years with annual lease payments of $70,100 being made at the beginning of the year. Building C: Purchase for $659,100 cash. This building is larger than needed; however, the excess space can be sublet for 27 years at a net annual rental of $6,470. Rental payments will be received at the end of each year. The Monty Inc. has no aversion to being a landlord. Click here to view factor tables. In which building would you recommend that The Monty Inc. locate, assuming a 12% cost of funds? (Round factor values to 5…

Please Don't use Ai solution

1. A grocery store chain must decide whether to build a regular or a large store in Future City. There is also the option of not opening any store at all. The decision depends on the market potential of Future City and this potential might be high, medium, or low. The potential profits in each case are shown in the payoff table below (in P1,000):   High Medium Low Regular 17,500 9,500 -3,000 Large 32,000 11,500 -4,500 None 0 0 0   Identify the decision to be made, the decision alternatives, the chance event and the states of nature for this problem. What alternative should be chosen under the maximax criterion? What is the payoff for this decision? Determine the minimax regret decision. Given that the probabilities of high, medium and low market potentials are 0.35, 0.45, and 0.2, respectively, determine the optimal decision using the Bayes’ decision rule (expected value approach).   2. Construct a decision tree for Problem #1 to help you in your decision analysis. What…

Please refer to the attached scenario If Brad decides to purchase a larger boat, what costs will be affected by this decision? Will they increase or decrease?

John Benson and Jerry Chen, the owners of J&J Bagel, Inc., have decided that it is time to acquirea bigger store to expand their operations. John and Jerry have identified a suitable structure that iscurrently for sale, and they believe they can buy and refurbish it for about $2.2 million. John and Jerry arenow ready to meet with Charlene Mons, the loan officer for Blue Hills Bank. The meeting is to discussthe mortgage options to the company to finance the new store.Charlene begins the meeting by discussing a 30-year mortgage. The loan would be repaid in equalannual installments. Because of the previous relationship between J&J Bagel and the bank, there wouldbe no closing costs for the loan. Charlene states that the interest rate of the loan would be 7 percent. Johnasks if a shorter mortgage loan is available. Charlene says that the bank does have a 15-year mortgageavailable at the same interest rate.Jerry decides to ask Charlene about a “bullet loan” he discussed with a…

Please help

reases Imagine yourself in the position of Thomas Pierce . president of Greymare Bus Lines. Your firm was established by your grandfather, who was quick to capitalize on the growing demand for transportation between Widdicombe and nearby townships. The company has owned all its vehicles from the time the company was formed: you are now reconsidering that policy. Your operating manager wants to buy a new bus costing $100,000. The bus will last only eight years before going to the scrap yard. You are convinced that investment In the additional equipment is worthwhile. However, the representative of the bus manufacturer has pointed out that her firm would also be willing to lease the bus to you for eight annual payments of $16,200 each. Greymare would remain responsible for all maintenance, Insurance, and operating expenses. If Greymare does not own the bus it cannot depreciate it and therefore, it gives up a valuable depreciation tax shield. We assume depreciation would be calculated…

Question: Calculate the initial outlay You have determined in your mind that you would like to have a business of your own, although your father runs a family restaurant in your local city. You have therefore, decided to have a medium size snack and cocktails bar which will accommodate the cruise ship passengers who visit your city. You plan to keep the business for five years after which you will sell it off to your brother John for $2,000,000 and go off to do your Master’s Degree in the UK. Though you will be occupying the establishment from your grandmother for free, you have decided that you need to make some improvements to the property which will cost you $1,500,000. Additionally, you will spend $275,000 in bar stools, tables and decorations. If this space had been leased out, it would have fetched a lease rental of $75,000 per year. You will depreciate the assets over 7 years using MACRS. You have determined that you would need an average cash balance of $15,000 and inventory of…

After a trip to Bordeaux, France, you are considering opening a restaurant based on Restaurant L'Entrecote. You will offer a fixed menu of salad, steak and french fries. You plan to run the restaurant for two years and then retire. Start-up costs, to be incurred immediately, are $500,000. Start-up costs include kitchen equipment, kitchen supplies, renovations, furniture, fixtures, and the point-of-sales system. Assume that all of those assets are classified as 5-year property (with depreciation rates of 20% and 32% in the first two years). The assets can be sold for $150,000 after two years. You expect 100 diners per night. The restaurant will be open for 300 nights per year. The average diner orders food with a menu price of $35 and beverages with a menu price of $15. Food costs are 34% of the menu price and beverage costs are 50% of the menu price. The nightly wages are $2,160 (for the chef, 5 kitchen staff, a bartender, the Maitre d', and 10 wait staff). Municipal tax, rent, and…

Do not give answer in image and hand writing