Busn379 - Part Ii Spreadsheet

In: Business and Management

Submitted By gsebasti
Words 707
Pages 3
Course Project Part II

Introduction
You will assume that you still work as a financial analyst for AirJet Best Parts, Inc. The company is considering a capital investment in a new machine and you are in charge of making a recommendation on the purchase based on (1) a given rate of return of 15% (Task 4) and (2) the firm’s cost of capital (Task 5).
Task 4. Capital Budgeting for a New Machine
A few months have now passed and AirJet Best Parts, Inc. is considering the purchase on a new machine that will increase the production of a special component significantly. The anticipated cash flows for the project are as follows:
Year 1 $1,100,000
Year 2 $1,450,000
Year 3 $1,300,000
Year 4 $950,000
You have now been tasked with providing a recommendation for the project based on the results of a Net Present Value Analysis. Assuming that the required rate of return is 15% and the initial cost of the machine is $3,000,000. 1. What is the project’s IRR? (10 pts)

2. What is the project’s NPV? (15 pts)

3. Should the company accept this project and why (or why not)? (5 pts)

4. Explain how depreciation will affect the present value of the project. (10 pts)

5. Provide examples of at least one of the following as it relates to the project: (5 pts each) a. Sunk Cost b. Opportunity cost c. Erosion

6. Explain how you would conduct a scenario and sensitivity analysis of the project. What would be some project-specific risks and market risks related to this project? (20 pts)
Task 5: Cost of Capital
AirJet Best Parts Inc. is now considering that the appropriate discount rate for the new machine should be the cost of capital and would like to determine it. You will assist in the process of obtaining this rate. 1. Compute the cost of debt. Assume AirJet Best Parts Inc. is considering issuing new…...

Similar Documents

Busn379 Part Ii

...Course Project Part II Introduction  You will assume that you still work as a financial analyst for AirJet Best Parts, Inc. The  company is considering a capital investment in a new machine and you are in charge of making a  recommendation on the purchase based on (1) a given rate of return of 15% (Task 4) and (2) the  firm’s cost of capital (Task 5).   Task 4. Capital Budgeting for a New Machine   A few months have now passed and AirJet Best Parts, Inc. is considering the purchase on a new  machine that will increase the production of a special component significantly. The anticipated  cash flows for the project are as follows:  Year 1 $1,100,000 Year 2 $1,450,000 Year 3 $1,300,000 Year 4 $950,000 You have now been tasked with providing a recommendation for the project based on the results  of a Net Present Value Analysis. Assuming that the required rate of return is 15% and the initial  cost of the machine is $3,000,000.  Required rate of return Year 0 1 2 3 4 Cash Flow  $       (3,000,000)  $          1,100,000   $          1,450,000   $          1,300,000   $             950,000     15% 1. What is the project’s IRR? (10 pts) = 22.38% 2. What is the project’s NPV? (15 pts) = $450,867.00 Computation of Net Present Value Year Cash Flow Present Factor  Present  @ 15% Value    0.8696 $ 956,522. 1  $ 1,100,000  2  $ 1,450,000  0.7561 $1,096,408. 3  $ 1,300,000  0.6575  $854...

Words: 1978 - Pages: 8

Busn379 Project Part 1

...BUSN-379 Course Project – Part 1 Task 1: Assessing loan options for AirJet Best Parts, Inc. The company needs to finance $8,000,000 for a new factory in Mexico. The funds will be obtained through a commercial loan and by issuing corporate bonds. Here is some of the information regarding the APRs offered by two well-known commercial banks. Bank APR Number of Times Compounded National First Prime Rate + 6.75% Semiannually Regions Best 13.17 Monthly 1. Assuming that AirJet Parts, Inc. is considering loans from National First and Regions Best, what are the EARs for these two banks? Hint for National Bank: Go to the St. Louis Federal Reserve Board’s website (http://research.stlouisfed.org/fred2/). Select “Interest Rates” and then “Prime Bank Loan Rate”. Use the latest MPRIME. Show your calculations. (15 pts) A. National First (MPRIME 3.25%) +6.75% = 10% Semiannually EAR = (1+.10/2) ^2 – 1 which is 10.25 B. Regions Best Rate is 13.17% Monthly EAR = (1+.1317/12) ^12 – 1 which is 13.99 2. Based on your calculations above, which of the two banks would you recommend and why? Explain your rationale. (15 pts) Based on the EAR calculations made in requirement 1, I recommend borrowing from National First. This is because Nation First APR of 3.25% + 6.75% = 10% semiannually is better then Regions Best of 13.17% monthly. 3. AirJet Best Parts, Inc. has decided to take a $6,950,000 loan being offered by Regions Best at 8.6% APR for 5 years.......

Words: 1154 - Pages: 5

Facility Planning Part Ii

...Facility Planning Part II HCS 446 Facility Planning Part II Introduction Development and growing a facility takes much time and contemplation with respect to regulatory requirements, budgets, planning and development of the building and the interior design of the building.   Making certain code requirements are met which is usually to help the architect and contractor. Many matters must be well-thought-out during the preliminary design created by the stakeholders in the blueprint.   Color collections used, which are satisfying physically and psychologically as well as noise reduction must be reflected when planning the facility.   Equipment and electronic items must be determined upon prior to construction of the facility. Cost estimate and budget planning are the first steps, which must be determined before the design of the facility. An implementation plan of the proposal from the preliminary phases of the plan of the facility through construction of the facility has to be arranged and charted. Regulatory requirements Health care facilities are required to follow the licensing regulations of their state in the design they use. Usually this is the 'Facility Guidelines Institute guidelines for design and construction of health care facilities' (Carr, 2010). The states require use of the codes in International Building and in addition, they need to be accredited by the 'Joint Commission on the Accreditation of Healthcare Organizations' (Carr, 2010).  The regulations......

Words: 1190 - Pages: 5

Busn379 Course Project Part 1

...Course Project – Part I Introduction The Course Project is an opportunity for you to apply concepts learned to a real-life simulation experience. Throughout the Course Project, you will assume that you work as a financial analyst for AirJet Best Parts, Inc. The Course Project is provided in two parts as follows: Part I – In Part I, you work with AirJet Best Parts, Inc. staff to identify the best loan options, as well as to valuate stocks and bonds. Part II – In Part II, you will provide the company with a recommendation for purchasing a new machine. You will base your recommendation on the Net Present Value (NPV) of the capital investment project using the cost of capital (WACC) as your discount rate. About AirJet Best Parts, Inc. AirJet Best Parts, Inc. is a company dedicated to the design and manufacturing of aviation and airplane technologies and parts. The company has commercial and military clients worldwide. Task 1: Assessing loan options for AirJet Best Parts, Inc. The company needs to finance $8,000,000 for a new factory in Mexico. The funds will be obtained through a commercial loan and by issuing corporate bonds. Here is some of the information regarding the APRs offered by two well-known commercial banks. Bank | APR | Number of Times Compounded | National First | Prime Rate + 6.75% | Semiannually | Regions Best | 13.17 | Monthly | 1. Assuming that AirJet Parts, Inc. is considering loans from National First and Regions Best, what......

Words: 2078 - Pages: 9

Strategic Plan Part Ii

...Strategic Plan Part II: SWOTT Analysis University of Phoenix Adventure Cruises is a small ship company that specializes in active and luxury adventures that are designed to provide unique experiences and bring you up close and personal with destinations. With two upscale yachts that hold 35 guests each, cruising with Adventure Cruises is a truly intimate experience. The experience is active and full of adventure, yet in relaxed luxury. Destinations include the Mediterranean, Northern Europe, Tahiti and South America. The small yachts will bring customers to some of the most desirable destinations around the world, including big cities and hidden gems. And internal and external SWOTT analysis will be conducted to determine the factors that have an impact on the success of the company. SWOTT is an acronym for strength, weakness, opportunities, threat, and critical threat. The analysis is used to evaluate and then improve a company’s current situation. Internal features are examined to see the different strengths and weaknesses, and opportunities and threats are examined to reveal external factors facing the business. Once the analysis is complete, it will help Adventure Cruises determine what they can do to stay competitive and successful in the industry. The SWOTT Analysis involves Adventure Cruises answering numerous questions regarding their strengths and weaknesses as well as any threats and trends of the company. There will be assessments of......

Words: 1810 - Pages: 8

Text Exercises, Part Ii

...Week 3 Text Exercises, Part II Exercise 82 in Ch. 10 * List the following elements in order of increasing electronegativity: Ba, N, F, Si, Cs * Answer : Cs (Cesium), Ba (Barium), Si (Silicon), N (Nitrogen), F (Fluorine). * Exercise 132 in Ch. 11 * Aerosol cans carry clear warnings against incineration because of the high pressures that can develop upon heating. Suppose a can contains a residual amount of gas at a pressure of 755 mm Hg and a temperature of 25 °C. What would the pressure be if the can were heated to 1155 °C? * Answer: Residual pressure: 755 mm Hg = 0.993 atm * Final pressure = ? * Start temperature = 25 °C = 298 K * Final temperature = 1155 °C = 1428 K * * Since the volume in the can then: * P1/T1 = P2/T2 * P2=(P1*T2)/T1= (0.993*1428)/298=4.76 atm = 3617.6 mm Hg * Exercise 50 in Ch. 12 * At the top of Mount. Everest, water boils at 70 °C. Explain why. * Answer: Water’s normal boiling point is considered at a pressure of 1 atmosphere—is 100 °C. A decrease in atmospheric pressure lowers the boiling point. At the top of Mount Everest the air pressure is about a third of the pressure at sea level. * Exercise 104 in Ch. 12 * Water does not easily remove grease from dirty hands because grease is nonpolar and water is polar; therefore they are immiscible. The addition of soap,......

Words: 313 - Pages: 2

Ethnicity and the Police Part Ii

...Ethnicity and the Police Part II: Final Deliverable Adriana Urrutia CJA/344 August 12th, 2013 University of Phoenix Law enforcement and the community have always had an off and on relationship. Like any other relationship they have their disagreements, misunderstandings and break-ups. However at the end of the day both sides share common interests, deterrence and justice. With the influx of immigrants in the past decades the United States has been bombarded with many different cultures and languages. Therefore society’s views and opinions of law enforcement vary from ethnicity to ethnicity. We will be exploring how the Asian, Hispanic and Black communities see law enforcement from discrimination, racial profiling and past experiences. Also, we will discuss how non-minorities view law enforcement and their actions. The shattered relations between law enforcement and minorities will be included in the discussion. In addition, the police officers and the rise of diversity and how they interact with the community, response to the growth of ethnic communities and education on diversity. Lastly, racial profiling and its effects on police officers, the community and the department will be explored. Ethnic Groups The increase of immigration and diversity has sometimes made relationships with police difficult. Asian and Hispanics communities are often fearful of police officers due to there past experiences. There past experiences vary from their country of origin that was...

Words: 302 - Pages: 2

Busn379 Project Part 1

...for AirJet Best Parts, Inc. The company needs to finance $8,000,000 for a new factory in Mexico. The funds will be obtained through a commercial loan and by issuing corporate bonds. Here is some of the information regarding the APRs offered by two well-known commercial banks. Bank | APR | Number of Times Compounded | National First | Prime Rate + 6.75% | Semiannually | Regions Best | 13.17 | Monthly | 1. Assuming that AirJet Parts, Inc. is considering loans from National First and Regions Best, what are the EARs for these two banks? Hint for National Bank: Go to the St. Louis Federal Reserve Board’s website (http://research.stlouisfed.org/fred2/). Select “Interest Rates” and then “Prime Bank Loan Rate”. Use the latest MPRIME. Show your calculations. (15 pts) A. National First Bank: EAR =[ ( 1 +{3% + 6.75%}/2 ) ^2 ]-1 EAR= 9.9% Regions Best: EAR =[ ( 1 +13.17%/12 ) ^12 ]-1 EAR =[ ( 1 +0.010975 ) ^12 ] -1 EAR = 13.99% EAR = 14% 2. Based on your calculations above, which of the two banks would you recommend and why? Explain your rationale. (15 pts) A. I would recommend National First Bank because the EAR is 9.9% whereas the EAR for Regions Best is 13.99% or 14%. Even if the APR for both banks are the same, National First would still have a lower EAR, the bank is compounded semi-annually opposed to Regions where it is monthly; the greatest frequency of compounding results in the highest EAR. 3. AirJet Best Parts, Inc. has......

Words: 1387 - Pages: 6

Timeline Part Ii

...Timeline Part II NOTE: Before starting the Timeline project please refer to the "Example Timeline Matrix" document. Instructions: Complete the matrix by providing the Time Period/Date(s) in column B, and the Description and Significance of the People/Event(s) to American History in column C. See complete instructions in the Syllabus for the Module 3 assignment entitled. “Timeline Part II.” NOTE: The timeline project does not need to be submitted to turnitin. NOTE: Please write your answers in a clear and concise manner. Limit your submission of the Timeline Part II up to 250 words per topic/subtopic. For example, if a topic is divided into 3 subtopics, you may write a maximum of 250 per subtopic listed. Be sure to cite all sources. Major Event/Epoch in American History | Time Period/Date(s) | Description and Significance of the People/Event(s) to American History | 1) The evolution of the institution of slavery from the Colonial Period to the 1860s. | 1619-1860 | At first, slaves could earn their freedom. When they did, slaves tended to own their own slaves. This is how it was up until 1750 when Georgia legalized slavery. Slavery was more needed in the south than the north due to the climate and ability to grow more crops. (Webmaster, 2011) Around 1808, the importation of slavery ended due to the rise in births. Blacks then made up 20% of the American population. | 2) The socio-cultural impact of the abolitionist movement including: a) The effect......

Words: 1557 - Pages: 7

Scrapbook Paper Part Ii

...Ethical Scrapbook: Part II James Bush CJS/211 September 14, 2015 Michael Raneses Ethical Scrapbook: Part II The twelve examples used in the Ethical Scrapbook: Part I will be analyzed in order to answer several questions. The examples in the scrapbook are in the following categories: Good Samaritan conduct or random acts of kindness Acts of vigilantism-violating the law to enforce the law Acts of civil disobedience-violating the law to change the law Criminal acts committed by professionals in the course of their employment Questions The following will be answered about the examples: Do you think the individual made the best decision possible given the circumstances? Could you see yourself acting similarly in similar circumstances? Example 1 the victim had her car stolen and she proceeded to give chase and grab bystander’s attention, she made the best decision possible however I don’t think this was very safe looking backwards but I probably would have done the same thing. Example 2 was a random act of kindness I do believe this was the thing to do and would like to think that I would be so kindhearted to react the same way and pay the blind man without any regards for heroism. The third example in this set is also random act of kindness and good Samaritans. The community worked together after a collision involving a mother and daughter. The people pulled her from the vehicle and waited with the child in the cool......

Words: 1423 - Pages: 6

Busn379 Course Project Part 1

...Course Project – Part I Introduction The Course Project is an opportunity for you to apply concepts learned to a real-life simulation experience. Throughout the Course Project, you will assume that you work as a financial analyst for AirJet Best Parts, Inc. The Course Project is provided in two parts as follows: Part I – In Part I, you work with AirJet Best Parts, Inc. staff to identify the best loan options, as well as to valuate stocks and bonds. Part II – In Part II, you will provide the company with a recommendation for purchasing a new machine. You will base your recommendation on the Net Present Value (NPV) of the capital investment project using the cost of capital (WACC) as your discount rate. About AirJet Best Parts, Inc. AirJet Best Parts, Inc. is a company dedicated to the design and manufacturing of aviation and airplane technologies and parts. The company has commercial and military clients worldwide. Task 1: Assessing loan options for AirJet Best Parts, Inc. The company needs to finance $8,000,000 for a new factory in Mexico. The funds will be obtained through a commercial loan and by issuing corporate bonds. Here is some of the information regarding the APRs offered by two well-known commercial banks. Bank | APR | Number of Times Compounded | National First | 3.25% Prime Rate + 6.75% | Semiannually | Regions Best | 13.17% | Monthly | 1. Assuming that AirJet Parts, Inc. is considering loans from National First and Regions Best,......

Words: 1689 - Pages: 7

Busn379 Course Project Part Ii

...Course Project Part II Introduction You will assume that you still work as a financial analyst for AirJet Best Parts, Inc. The company is considering a capital investment in a new machine and you are in charge of making a recommendation on the purchase based on (1) a given rate of return of 15% (Task 4) and (2) the firm’s cost of capital (Task 5). Task 4. Capital Budgeting for a New Machine A few months have now passed and AirJet Best Parts, Inc. is considering the purchase on a new machine that will increase the production of a special component significantly. The anticipated cash flows for the project are as follows: Year 1 $1,100,000 Year 2 $1,450,000 Year 3 $1,300,000 Year 4 $950,000 You have now been tasked with providing a recommendation for the project based on the results of a Net Present Value Analysis. Assuming that the required rate of return is 15% and the initial cost of the machine is $3,000,000. 1. What is the project’s IRR? (10 pts) 2. What is the project’s NPV? (15 pts) 3. Should the company accept this project and why (or why not)? (5 pts) 4. Explain how depreciation will affect the present value of the project. (10 pts) 5. Provide examples of at least one of the following as it relates to the project: (5 pts each) a. Sunk Cost b. Opportunity cost c. Erosion 6. Explain how you would conduct a scenario and sensitivity analysis of the project. What would be some......

Words: 711 - Pages: 3

Strategic Plan Part Ii

...Strategic Plan, Part II: SWOTT Analysis Integrated Business Topics/BUS475 Strategic Plan, Part II: SWOTT Analysis The purpose of this paper is a synopsis that the author will analyze seven of the forces and trends that Lusti Laundromat must take into consideration including economic, legal and regulatory. The author will describe how the company adapts to changes, and analyze the supply chain operations. By identifying the major issues or opportunities that the company faces with the synopsis, the author can generate a hypothesis surrounding each issue and research questions. The author will conclude by identifying the circumstances surrounding each issue, classifying the circumstances; attributing the importance of each classification; and test the accuracy of the importance for each classification. Strategic Planning is a tool the organizations use to concentrate its energy, to ensure that the workforce and all members of the company are working towards the same goal previously establish. The primary purpose of strategic planning is to assess and adjust the organization’s direction in response to a changing environment. Strategic planning is necessary to allow the firm to keep its competitive advantage, and that is what makes the difference on successful companies. For Lusti Laundromat, a coin laundry store in South Florida, the administration understand the importance of strategic planning to pursue the goals previously set and to make sure the workforce meets the......

Words: 1433 - Pages: 6

Decisions in Paradise Part Ii

...Decisions in Paradise Part II Lisa M. Campbell MGT/350 December 19, 2011 Professor Rebecca Marek Decisions in Paradise Part II The decision to open a hotel on the island of Kava has been a challenge for owner Lisa Campbell. Decision-making and numerous situations are evaluated to ensure this decision-making will be best not only for the hotel but also that it will benefit the local islanders and the people who visit Kava temporarily. The Marriott Kava hotel is projected to be a medium size facility. The accommodations will ensure local islanders, patients receiving extended health care at the local cancer center, families, couples, and even business travelers will have a place to stay during their visit. The decision is if it will be more beneficial to build a standalone hotel in the middle of the island, merge the business with the local cancer center, or build the hotel near the airport ensuring it is near the new transit shuttle bus company. Building a standalone hotel ensures that if the tourism and visitor rate to the island increases the hotel will have no obligations and commitments to another company and able to focus on just providing space for guest of the hotel. The downside of this is that the business owner limits herself to other business opportunities if the standalone method is sought after. Business is based on the needs of living areas on a temporary basis. The developer that has come to the island to build housing projects for the...

Words: 897 - Pages: 4

Ethics Scrapbook Part Ii

...Ethical Scrapbook Part II Students Name CJA/324 Ethics in Criminal Justice Date Instructor Ethical Scrapbook Part II Ethics are a part of nearly everything that we as a society do. Whether we are late for work or even filing your federal taxes, an ethical decision is being made. Life is about choices, morals, and principles. In the field of criminal justice, ethics can be applied as well. Just as police are sworn to serve and protect by oath for the principles by which they are governed, so are most professions today. “Should All Jurisdictions Have a Good Samaritan Law Requiring an Individual to Help Another if They Are Able?” Requiring persons to help another when they are able without percussions of being sued against death or permanent damage to the victim has been helpful in certain situations where ambulatory assistance has not yet arrived. Often times a person can prevent death or stabilize a person until help arrives. If a person moves another person in need and actually causes permanent damage to them, they are not held accountable for that; in other words, they cannot be sued. I believe that there should be a law regarding Good Samaritans; however, I do not believe that it should be required. While the law is helpful, it can also be hurtful. For example, going back to my example above, should the person in need now be permanently immobilized, they cannot go after the person that helped for financial or medical money or charges incurred......

Words: 2280 - Pages: 10

无尽之剑2iphone/ipad版 | Justine Clarke | Disclamer / DMCA