Financial Plan Worksheet 2 - Word (Unlicensed Product) A Amruthavarshini sadineni X File Home Insert Design Layout References Mailings Review View Help Tell me what you want to do Cut - 16 - A A Aa A Find Copy Normal No Spacing Heading 1 Heading 2 Title Subtitle Gac Replace Paste Format Painter B IU~ abe X2 X? A~ A ~ Select Clipboard Font Paragraph Styles Editing i NOTICE Most features are disabled because your Office product is inactive. To use for free, sign in and use the Web version. Activate Use free at Office.com X Financial Plan Exercise BG&E will pay me $0.07 per kWh for energy I produce each year Making a Financial Projection The solar power plant is guaranteed to produce 20,000 kWh per year for the next 20 years The Tesla salesperson gave me a quote of $50,000 for the solar power plant Solar Power installation Tesla says that I should plan on maintenance for the installation to be 1% per year of the I have a small business that is an arts and crafts manufacturing operation. I have hired artists installation cost who make paintings, pottery, jewelry, lawn sculptures, etc. It is a profitable business, but only modestly so. I have conducted a SWOT analysis and I have looked at capitalizing on my strength I have $20,000 cash I can invest to expand the operation to make more money, but I don't seem to have a local market that can I will need to borrow $30,000 and my bank will charge me 5% interest (cost of capital) support the increased sales I would want. Instead I am now focused on my largest weakness, the cost of electricity to run my operations. I have confirmed that I will receive $12,000 back on my taxes next year if I make this investment I was recently approached by someone from Elon Musk's company, Tesla, about installing a When I get the tax money, I will immediately use it to pay down part of the $30,000 that I borrow solar power plant on my building. She said that I can lower my costs by getting "free electricity from the sun" by installing a photovoltaic system. I am smart enough to know that there is no such thing as "free", but I am wondering if it makes strategic sense for me to generate my own power. I wonder how long it will take to recoup my investment in the solar power plant. I To complete this assignment you will need to prepare a cash flow analysis that takes your wonder if the internal rate of return on the project would make this attractive. I have some revenue (money saved by not purchasing electricity plus money made by selling your SREC each year) and deducts your expenses (maintenance cost, plus the cost of borrowing $30,000) to extra cash on hand but wonder if it would be good to invest in this idea, or better to put the money into a mutual fund. I don't have enough cash to fund the construction of the whole solar come up with how much more profitable this makes your business each year. I suggest you run power plant. I will have to borrow some funds to complete the project. this cash flow analysis out for at least 20 years, the life of the solar power plant. Once you have the cash flow analysis you will be able to use that information to calculate the payback period, In addition to generating my own power, I can also sell "Solar Renewable Energy Credits" IRR and NPV for the solar power plant investment idea. (SREC). The state of Maryland recently passed a law that calls for 12% of the energy generated in the state of Maryland to be produced via solar photovoltaics. If power companies don't With the information provided by this financial analysis, please make a recommendation on generate this themselves, they can purchase the solar credit rights that my business produces. whether or not I should proceed with this project. As an additional incentive, the federal government will give me a tax credit equal to 24% of my investment in the year following the installation of my solar power plant. Please help me with my strategic business decision creating some financial projections. These can be generated by answering the following questions: What would the payback period be for this business idea? What would the internal rate of return be (IRR)? What is the net present value (NPV) of the business idea? Page 2 of 2 697 words Accessibility: Good to go Eo + 73% 32.F Q Search 11:15 AM 3 emps rise 3/19/2023