I have a class project I need help with. It's inbasic business accounting, but in another mayor that has nothing to do with business accounting.

I have to create this project almostlike, but not similar, the example attached called Example1 Sunshine Power.pdf, seeattached, using the costdata and other business data in the Project Case-Fuel Cell Electricity.doc, attached as well. Keeping in mind the Term project guidelines as per attached doc. The project must include the income statement, cash flow statement in excel with the appropriate formula in each datasquare. I need this by 25 July 2016 5pm US Eastern Time Zone. Can you help me??

Thank you very much.

Sunshine Power LLC Caribbean Island Solar Power - Financial Proposal Prepared By: Table of Contents Executive Summary .......................................................................................................................... 2 Project Details ....................................................................................................................................... 2 Financial Analysis .............................................................................................................................. 3 Risks and Opportunities - Sensitivity Analysis ........................................................... 4 Risks and Opportunities - Scenario Analysis ................................................................ 7 Additional Project Opportunities .......................................................................................... 8 Recommendation ................................................................................................................................ 8 References .......................Financial Analysis Document (Attached Excel Doc) Reference 1: Project Financial Data Block Reference 2: Income Statement Reference 3: Cash Flow Statement Reference 4: Internal Rate of Return & Net Present Value Analysis Reference 5: Simplified Income Statement Reference 6: Simplified Cash Flow Statement Reference 7: Risk / Opportunity Analysis Tables & Graphs 1 Executive Summary: The island government of Antigua has provided our company with an opportunity, to not only make a profit but also help in the fight against global climate change at the same time. The Antigua government has asked us to create a solar field on their island which will provide a clean inexpensive alternative to their current expensive oil generated power. This proposed project will begin as an initial 20 year contract, with a contract extension possible after the first 20 years. At the end of year 20 the Internal Rate of Return (IRR) would be 16.44%; this is above the company standard MARR of 15%. Additionally the project will begin to produce a positive net present worth in year 18. If this contract is renewed the IRR has the potential to be even larger. This project does face a few risks however, these include sensitivity to customer demand, and possible admin cost increases during the project life, these risks if mitigated should not pose a threat to the project's profitability. Additionally if this project goes well it has the potential to open up new business on other Caribbean Islands or near other major cities on the Island of Antigua. Project Details: Sunshine Power LLC has been asked to create a solar field on Antigua. The Island government will provide the land. Sunshine Power will provide all the solar power generating equipment, auxiliary storage for nights and for days when sunlight is not available, and will operate the solar power field. The contract for the project will be for 20 years and the upfront investment cost for Sunshine is estimated at $1,500,000. Additionally every five years, in years 5, 10, 15 and 20, an added investment of $200,000 will need to be made to replace hardware as needed and to increase capacity. The estimated annual administrative costs for operating the solar field are $180,000 for salaries and benefits, $12,000 for administrative costs, $80,000 for maintenance, $120,000 for security, and $50,000 for insurance coverage for wind and water damage. These general and administrative values will be fixed at these amounts for the duration of the contract. The demand is expected to average 1,000,000 Kilowatt hour (KwH) per year in year 1 and increase 10% annually thereafter. The operating costs of the solar field are expected to be $.02 per KwH. The compensation from the Island government to Sunshine Power, LLC will be $.65 per KwH in year 1, and decrease by $0.05 per year until year 7 when it will be $0.35 per KwH. It will stay constant at $0.35 for the remaining years of the contract. 2 No Income tax will be assessed by the island government, however the income will be taxed at the standard rate of 15% when it is repatriated to the U.S. Tax credits from this project, can be used to offset taxes from other U.S. based projects. After the initial 20 year contract is completed it will come up for renewal, if the contract is not renewed Sunshine LLC will receive $500,000. Additionally if this contract is successful, many additional projects are possible on other islands or via expansion on the Island of Antigua. Financial Analysis (Based on Expected Values): A simplified income statement can be found below (a more detailed income statement can be found in the financial analysis excel document that is attached to this report). This income statement is based on the financial values found in the data block section of the attached excel document. This income statement shows that the project will begin to show a yearly profit in Year 6. The income statement also shows that a profit will be made from year 6 until the completion of the project. Additionally once the project becomes profitable in year 6 the rate of profitability increases through year 20. Simplified Income Statement A simplified cash flow statement can be found below for this project (A more detailed statement can be found in the attached financial analysis document). This cash flow statement shows that each year after the initial investment will produce a positive cash flow and generally most follow on years will bring in progressively larger cash flows to Sunshine LLC. 3 Simplified Cash Flow Statement Based on company policy a project can only be initiated if it meets or exceeds the minimum acceptable rate of return (MARR), which is currently set at 15%. This project beats this standard by providing an internal rate of return (IRR) of ~16.44% over the 20 year duration of the project. Additionally the project provides a net present value (NPV) of $185,933 (based on the company MARR rate). Present Worth / Internal Rate of Return Risks and Opportunities - Sensitivity Analysis: In order to show how change may affect this project sensitivity analyses are shown. In these sensitivity analyses one variable at a time was changed well the rest were held constant, this shows which variables are the most important to the financial health of the project. Based on these sensitivity analyses it was found that the length of the project, the consumer demand, the possibility for contract renewal, and the admin expenses were all sensitive factors in the health of the project. Further details about each factor can be found below. 4 Project Length Analysis $400,000.00 Net Present Value $200,000.00 $0.00 ($200,000.00) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 ($400,000.00) ($600,000.00) ($800,000.00) ($1,000,000.00) ($1,200,000.00) ($1,400,000.00) Years Project Length - This graph shows the effect on NPV if the project terminates prior to the end of the 20 year contract. As can be seen the project does not cross the breakeven point until year 18. Project Demand Analysis $1,200,000.00 Net Present Value $1,000,000.00 $800,000.00 $600,000.00 $400,000.00 $200,000.00 $0.00 ($200,000.00) ($400,000.00) ($600,000.00) Yearly Demand Increase Demand Analysis - This graph shows the effect of changes to the yearly demand increase, if the demand decreases by just 1% from the expected value the net present value becomes negative. 5 Net Present Value Initial Investment Analysis $400,000.00 $350,000.00 $300,000.00 $250,000.00 $200,000.00 $150,000.00 $100,000.00 $50,000.00 $0.00 Initial Investment Amount Initial Investment Analysis - This graph shows the effect on changes to the initial investment amount. The initial investment amount can be increased by up to $200,000 and the project will still maintain a positive net present value. Admin Operating Cost Analysis $150,000.00 Net Present Worth $100,000.00 $50,000.00 $0.00 ($50,000.00) 0.5% 1% 1.5% 2% 2.5% 3% ($100,000.00) ($150,000.00) ($200,000.00) ($250,000.00) ($300,000.00) Annual Increase to Admin Operating Expenses Admin Operating Cost Analysis - This graph shows the effect on changes to the admin operating expenses. Per the financial baseline the admin operating expenses will remain constant over the 20 year project however there is a significant risk to the project's financials if this is not accurate. If the admin operating costs rise with the historical average inflation (3%) the project will not beat the company MARR at any point during its operation. 6 Project Renewal Analysis $1,000,000.00 Net Present Value $500,000.00 $0.00 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ($500,000.00) ($1,000,000.00) ($1,500,000.00) Years Project Renewal Analysis - This graph shows the long term effect if the island government renews the contract (at current contract rates). If the government renews the project for an additional 10 years the net present worth at year 30 would be $870,304 and it would push the internal rate of return for the project to 19.2%. This project becomes financially more sound for each additional year of operation. Risks and Opportunities - Scenario Analysis: In these two scenario analyses a worst and best scenario are included in order to show what this project is capable of producing when multiple variables are all modified in conjunction with one another. These results are found below. Project Worst Case Scenario Initial Demand Increase 7% Investment $1,700,000 Internal Rate Admin Increase 3% of Return -24.40% PW of Proposal ($1,239,613.40) Project Best Case Scenario Initial Demand Increase 13% Investment 7 $1,300,000 Internal Rate of Return 23.40% $1,244,075.14 Admin Increase 0% PW of Proposal Additional Project Opportunities: If this contract is executed successfully it may open up future business on neighboring islands or near other major cities on the Island of Antigua. These additional projects would be able to utilize many of the same administrative functions that will be used on this solar power project. By sharing these admin functions future projects would be able to lower their fixed expenses and push their profits higher. Additionally our company will have the opportunity to help in the fight against global climate change. Recommendation: I recommend that Sunshine LLC. take on this solar power project on the island of Antigua. The project gives our company the opportunity to not only make a solid profit but it will also allow us to help in the fight against global climate change. At the end of the project estimates show an internal rate of return of 16.44%; this is healthily above the company standard MARR of 15%. There are a few risks that our company should try to mitigate if possible. These risks include a breakeven point that is late in the project's life (year 18), sensitivity to customer demand, and the threat of possible admin cost increases during the project. If these can be mitigated via negotiation with the Antigua government or internally within our company the project would be more secure against fluctuations from the baseline. There are also a few opportunities our company should try to take advantage of. These opportunities include project contract renewal and future business opportunities on neighboring islands. This is a good opportunity and our company should take advantage of it. 8 0 Twenty Year MACRS Five Year MACRS 1 3.750% 20.00% 2 7.219% 32.00% 3 6.677% 19.20% 4 6.177% 11.52% 5 5.713% 11.52% 6 5.285% 5.76% 7 4.888% 8 4.522% 9 4.462% 10 4.461% 11 4.462% FUEL CELL ELECTRICITY: PROJECT, SUMMER 2016 Fuel cell technology, that found its first major application in the space program, is a growing electricity source for corporations, universities, cities and homes. Reportedly Toyota and Honda (and probably others) are developing fuel cells for use in automobiles. Fuel cells require hydrogen fuel that can be derived from natural or propane gas, and operational costs as much as 50% of burning fossil fuels. However, the procurement of fuels can be problematical and the investment costs are substantial. The references below, including a video from \"60 Minutes\Term Project Guidelines Financial Proposal in Weeks 9, 10 and 11 Summer 2016 The TMAN 625 term project is an individual one to prepare a financial analysis and report of an assigned case that is to be accomplished in weeks 9 though 11. There are no assignments in these weeks, but there are content and discussion questions to assist in learning the content. The task is to prepare a written proposal that a reader (CEO, CFO, investment committee, etc.) will use to determine if a proposed project should be approved. It is not a marketing document for a customer. It is not a research paper. Rather it is an applied exercise using the concepts of the course. The requirements of this project are 1) a spreadsheet containing the financial analysis, and 2) a written report discussing the proposed project. The written report should contain a cover page, executive summary, and a discussion of the proposal. This discussion report should summarize the project in more depth than the executive summary, evaluate the proposal using the financial and strategic objectives of the company, detail relevant (to the CEO) assumptions, and note risks. All needed files are in the project discussion, including some example reports from previous semesters. Questions concerning this project can be posted in this discussion topic or emailed to the professor. Submit the financial analysis as a MS Word document and an Excel workbook in the assignment area of the course room. Submit the final report no later than the end of week 11. The final report should be 8-12 pages in length. The length limit of the report includes the cover page, executive summary, the proposal and appendices if any. The length does not include the separate Excel workbook. A length more than 12 pages will be penalized. The grading criterion is quality, not quantity. While relevant financial statements should be in the Word document, condensed versions may be sufficient. A complete set of statements should be submitted in the separate Excel file. APA Since this is a project for preparing a financial proposal for an executive rather than a research paper, APA format is not required. There are not a required number of references. But there is a requirement, inherent in all writing, that if the creative work of others is used it must be cited. TurnItIn TurnItIn is required for all graduate school papers and therefore you must submit your finished paper to TurnItIn. Directions for TurnItIn are posted in the Turnitin discussion topic. Although students must do the submission to TurnItIn and can make multiple submissions to remove problem areas, the results of the final version will be retrieved from the TurnItIn site by the professor when the paper is graded. That is, do not submit the TurnItIn report. As more students submit papers for the project, the TurnItIn percentages start to rise since the basic terminology is the same in all papers and everyone is describing the same case. Look at what is flagged by TurnItIn more than the percentage. Use TurnItIn to find sentences that should be in quotes, sentences that are identical, etc. Do not spend hours trying to get it to be very small or zero. Writing a Proposal Consider the following when preparing a business proposal. These are based on a book by Tom Sant (2004) entitled Persuasive Business Proposals, First and foremost, focus on the reader, their background, and their needs from the report. Do not include any definitions, etc. that an executive should already know, and especially not include anything that tells the executive how to do their job. The focus must be on the project and its relevance to the company, not you the writer. It is not a resume. Therefore, formal business proposals should not contain personal pronouns like \"I\