Hello, this is a question from the case study found below. I uploaded the complete case study.

It is only one question.

Based on Mr. Suzuki's estimate of 1-3% growth rate of Saito Solar's free cash flows over the next 20 years, how much would Saito Solar be valued at? The owners required rate of return was 10%.

THUNDERBIRD SCHOOL OF GLOBAL MANAGEMENT A06 - 13- 0:020 1 , 2015 LENA BOOTH* FRANK TUZZOLINO SAITO SOLAR - DISCOUNTED CASH FLOW VALUATION 8 , 2014 to Mar 31 . On a late November morning in 2012 , a boutique investment bank in Japan approached Mr. Takuya Saito , founder and CEO of Saito Solar , about his interest in selling the firm . Even though selling the firm had crossed from Sep 28 , } his mind occasionally in the past , Mr. Saito had never seriously thought about who would be a potential buyer* and how much the firm could realistically be sold for . He was excited about the interest shown by the investment* bank , yet skeptical about how large the offer might be , in light of the declining sales in recent years . Nevertheless , he invited his two silent partners , Mr. Kenta Suzuki and Mr. Shinji Yoshida , to gather in his office to discuss this unsolicited proposal . By Shareen Holmer { Saito Solar and the Solar Energy Industry* Saito Solar is a privately owned photovoltaic ( PV ) solar panel manufacturer founded by Mr. Takuya Saito in 2002 Mr. Saito worked as an electrical engineer for Monsanto Electronic Materials Company ( MEMC ) , a silicon - wafer 18join 14 of London taught by } company , right after finishing graduate school in the U.S. In 2000 , after several years of dismal financial results , MEMC was acquired by Texas Pacific Group , a private equity firm , for a symbolic dollar plus $150 million of credit lines . It was then that Mr. Saito decided to return to his homeland , Japan .* Mr. Saito had always been intrigued by , and was a big believer in , alternative energy while he was in the * University U. S. He was particularly interested in solar energy and had spent many of his leisure hours studying the various* processes of solar energy production . He understood how solar cells , electrical devices that are used to generate* se parameters is electricity from sunlight through photovoltaic effect , were connected electrically , usually in a series as a module . Multiple solar cells were then integrated into groups , all arranged on one plane , forming a solar panel . His research Royal Holloway . also showed that most of the solar panels in the world were made of either mono - crystalline or polycrystalline* side the ( also called multi - crystalline ) silicon solar cells , with those made of thin- film solar cells accounting for only a small fraction of the overall solar market .* sino a Mr. Saito believed Japanese residential and commercial properties would use a lot more solar energy if solar panels were durable and cost effective . After months of extensive industry research , he determined that solar panels made of polycrystalline silicon cells would have the most potential in Japan . Polycrystalline silicon costs* less to produce compared to mono-crystalline because in this process , raw silicon is melted and poured into a square mold , which is then cooled and cut into perfectly square wafers , resulting in less waste . While the efficiency level is slightly lower than mono - crystalline silicon , polycrystalline silicon-based solar panels are more cost effect- tive and would be very appealing in Japan , especially to residential customers . The thin- film solar panels , while* cheap to manufacture , are the least efficient in producing electricity . !" They take up four times as much space as Authorized for use only in the course Financial Economics at the mono - crystalline silicon- based panels to produce the same amount of electricity , making it very impractical for Japanese residential customers .* Mr. Saito spent the next few months soliciting capital to start his company . As a newcomer to the solar in - dustry , he encountered many roadblocks , especially from banks and finance companies . Even though he had saved some money during the 20 years he worked at MTEMC , it was not enough to start a solar panel manufacturing Mathias Aarre Machlum , " Which Solar Panel Type is Best ? Mono - vs . Polycrystalline vs . Thin Film , " June 27 , 2013 . ( http : / / energy informative . org / best- solar - panel - monocrystalline - polycrystalline - thin - film! ) Copyright @ 2013 Thunderbird School of Global Management . All rights reserved . This case was prepared by Professors Lend Chua Booth and Frank Tuzzoling for the purpose of classroom discussion only', and not to indicate either effective or ineffective management .Exhibit 1 . Various Types of Solar Panels Polycrystalline solar panels Mono - crystalline solar panels Thin film solar panels He these parameters is a copyright violation .\\ firm , even at a small scale . Finally , through family ties , he was able to convince a couple of his father's wealthy , Authorized for use only in the course Financial Economics at Royal Holloway . University of London taught by Shareen Holmer from Sep 28 , 20 14 to Mar 31 , 2015 . long - time friends , Mr. Suzuki and Mr. Yoshida , to contribute the remaining needed capital to start Saito Solar .* Saito Solar was a niche player serving residential and small commercial customers , with superior customer * service as it's hallmark . Mr. Saito recruited many of his customers by first educating them on the importance of alternative energy for Japan , and how they could play a role in helping the environment by adopting solar energy for their homes or businesses . Coupled with the exponential growth of the Japanese solar industry during that Sino a time , Saito Solar's revenue grew more than eight-fold from 2002 - 2008 . It was able to prosper along with other* industry leaders in Japan such as Sharp , Kyocera , Mitsubishi , and others .* In 2008 , the global financial crisis hit . Energy prices fell significantly , bringing down the demand for alter - native energy , including solar power . At the same time , many Chinese solar companies , such as Suntech , Yingli Solar , and Trina Solar , flooded the market with solar panels that were 30 - 40% cheaper than those made in Japan . ? Even though the quality of Japanese solar panels was considered superior , the cost difference was too big in this rapidly commoditized industry for Japanese companies to compete in the world market . Many industry leaders* in Japan , such as Sharp and Kyocera , suffered loss of market share . Saito Solar had a hard time competing as well , with its revenue steadily declining and net profit margins declining also , to about 4 . 2%/0 in 2012 ( see Exhibit 2 ) . From 2009 - 2012 , crude oil prices started to creep back up , reaching over US$100 per barrel in parts of 201 1 and in the spring of 2012 . World demand for solar energy rose rapidly again , boosted also by the feed- in tariffs implemented by many nations around the world . ' In Japan , a deadly earthquake hit in 201 1 , causing* explosions and problems at some of the nuclear power plants that were compounded by the ensuing tsunami . Abbishek Shah , " Will Cheap Chinese Solar Panels Invade Japan ? " July 17 , 2012 . ( www. greenchipstocks . com/articles / japan - solar - companies / 2056 )` ' A feed- in tariff , also called advanced renewable tariff or renewable energy payment , is a mechanism used to promote* investment in renewable energy technologies . This is often achieved by offering renewable energy producers long-term contracts at an attractive price to ensure they achieve superior return . As for 2010 , more than SO nations have enacted feed - in tariff policies . See http : / / en . wikipedia. org / wiki/ Feed _ in_ tariff for more details . A06 - 13- 0020Exhibit 2 . Saito Solar's Revenue and Net Profit Margin 5. 2 % \\Uu uus'" ) * 3. 4 /0 5. 090 * 6, GOO.CO 4.8%0 A . ^` * * 6, 50.0. 00 Margin * 6, 400. 010 $ 6 . 833. 20 ` X6, 3.00. 00 1. 1:0 } profit *6 , 200. 00 $6. 52} 4. 290 #` X6, 100. 00 16.3:45 $ 6 , 23` * 6, 000. 00 4. 0% of London taught by Shareen Holmer from Sep 28 , 2014 to Mar 31 , 2015. * 5, YOU. 00 $3. 8% 2009 2010 2011 20112 * Revenue Net Profit Margin At the time of the earthquake , Japan had 5 4 nuclear reactors and 17 power plants that produced about 30 %/ of Japan's electricity .* In addition to the threat from radiation , many areas of Japan were without power . Nearly* sixteen thousand people died and the Japanese economy suffered severely , causing damage totaling about US$ 300 billion . The earthquake and tsunami gave Japan a sense of urgency to look for alternative energy . On June 18 , 2012 , the Japanese government approved a new feed - in tariff of 42* / K Wh ( about US$0. 53 / K Wh ) for solar energy that would take effect on July 1 , 2012 . This tariff was almost twice as large of that in Germany , the country with is a Cl the largest solar energy capacity in the world , and three times of that in China . With this new tariff , Japan was predicted to generate at least US$9.6 billion of new investments in solar installations , according to Bloomberg* ly , University Of New Energy Finance forecast .'" These investments were expected to generate up to 3 . 2 GW of additional capacity* se parameters is about the output of three nuclear plants , and would rank Japan as one of the largest in the world in solar capacity . Valuation of Saito Solar* side the It was early afternoon when the two silent partners , Mr. Suzuki and Mr. Yoshida , arrived at Mr. Saito's office . They were both very excited about the solicitation and wanted to know how much the offer was . Mr. Saito eouts explained that the investment bank revealed nothing unless owners of the firm agreed to open up a conversation about the sale . That was the main reason he wanted to meet with his two partners . Besides figuring out if the partners were receptive to the sale of the company , Mr. Saito also wanted to know if they had some idea as to how much they would sell the company for ." Mr. Yoshida's Valuation* Authorized for use only in the course Financial Economics at Royal Holloway . Mr. Yoshida was especially interested in the sale of the firm because he needed the cash to invest in his son's new venture . He was a retired mechanical engineer who made some of his earlier fortune through a few lucrative real estate deals during the Japanese real estate boom in the late 1980s . He had since invested in a few businesses , all as a minority , silent partner , including Saito Solar . He thought that Saito Solar should be worth about $ 5 billion . His calculation was simple and straightforward . He argued that the firm was generating about $250 million of* net cash flows per year , and he believed these cash flows were likely to continue for the next 20 years . He came* out with $ 5 billion by simply multiplying $ 250 million by 20 .* " Japan Earthquake - Tsunami Fun Facts , " CNN Library , September 20 , 2013 . ( http : / / www . cnn . com / 2013 / 07 / 17 / world ! asia / japan - earthquake _ _ _ tsunami - fast- facts / index . html )` ' Kivu Liu , " Sunny Days Ahead For Japan's Solar Market , " China Daily , July 2, 2012 . ( http: / / www . chinadaily . com . call world / 2012 - 07/ 02 / content _ 15 5 410864. htm )\\ A06 - 13- 0020Mr. Suzuki's Valuation* Mr. Suzuki did not agree with the way Mr. Yoshida estimated the firm value . After inheriting a sizable estate from* his father 15 years ago , Mr. Suzuki had been working with a financial advisor and had gained some financial knowledge . He argued that cash flows in the future are not worth as much as cash flows today , so they have to 1 , 2015. be discounted . If future cash flows were to stay constant for the next 20 years as Mr. Yoshida suggested , the firm* would be worth much less than $5 billion after those cash flows are discounted . However , he did not think cash flows of the firm would stay constant . He was confident that the new feed- in tariff passed recently would increase* 8 , 2014 to Mar 31 .` the demand for solar panels , and that would increase the firm's net cash flows . He believed net cash flows should increase by 3 - 5% per year over the next 20 years . He just needed to make that calculation after he determined what to use as a discount rate ." ' from Sep 28 ,` Mr. Saito's Valuation* Mr. Saito was glad that Mr. Suzuki understood the discounted cash flow concept and its importance in valuation . He agreed that the firm would get some much- needed sales boosts in the coming years due to the new feed - in tariff that started in July . As the majority owner who oversaw the day- to-day operation of Saito Solar , he had* witnessed an increase in sales orders since the new tariff was passed . Unlike Mr. Suzuki , he didn't think the sales growth would be steady over the 20 - year period . He believed sales growth would be quite substantial in the first* few years when consumers and businesses responded to the change in the new tariff , but it would taper off . He of London taught by Shareen Holmer*$ also didn't believe that the firm would stop producing cash flows after 20 years . He argued that the company* would be in good hands , and hence should exist for the indefinite future . He explained that most companies " discounted cash flow valuations were based on firms producing perpetual cash Hows , as there was no reason for a firm's cash flows to disappear after a certain period ." a copyright vil In fact , Mr. Saito came to the meeting well prepared . Before the meeting , he asked his finance manager , MS. Yamada , to prepare the 5- year cash flow projections shown in Exhibit 3 , with the details presented in Ap - bendix 3 . The projection had an aggressive sales growth in the near future , with growth slowing in later years . MS. Yamada , who had since joined the meeting , also suggested that cash flows beyond the 5- year period should be growing at a constant rate of 1 - 3%/0 . After some clarifications and discussions , the partners were convinced* He these parameters is that the projections in Exhibit 3 were reasonable ." sat Royal Holloway , 4 Exhibit 3 . Saito Solar's Actual and Projected Sales and Free Cash Flows @ outside the * 14, 000 * 628 * 700 * 607 * 12 , 000* $ 539 * 600 * 10, 000 * 465 * 500 suomiur ) s * 396 millions * 8, 000 * 400 $ 6,000 Authorized for use only in the course Financial Economics at* Sales ! * 11 , 8:29 * 12 , 421 * 300 ? * 4, 000 $ 7, 793 *9, 3.51 * 10 , 754 rec Cash! $ 6, 23 41 * 2, 000 * 100 XO 2012 2013 2014 2015 2016 2017 _Projected Sales _Free Cash Flows* AD6 - 13- 0020Next, Ms. Yamada needed to determine the discount rate, which is the cost of capital for the rm. Since Saito Solar had no debt, the discount rate would be what the owners expected to earn in this business. When the three partners started the business in 2002, they determined that to properly account for the risks inherent in this business, they expected to earn a minimum of 10% return on their equity capital. Ms. Yamada veried and conrmed that the partners had not changed their expectations over the years. "With this last piece of in- formation and some sensitivity analyses, Ms. Yamada was able to project a range of rm values for the partners. A0613-0020 5 Authorized for use only in the course Financial Economics at Royal Holloway, University of London taught by Shareen Holmer from Sep 28' 2014 to Mar 31. 2015. Use outside these parameters is a copyright violation. Appendix 1 . Saito Solar , Profit and Loss Statement ( millions of Yen , year ending June 30 ) Income Item 2009 2010 201 1 2012 Sales 6. 833. 2 6, 755. 7 5, 345 . 1 6, 234. 1 COGS 4. 323. 2 1 . 298 . 1 1 , 1 12.0 4. 041 . 9 Gross margin 2, 509. 5 2 , 457. 6 2, 233. 1 2 , 192.2 Gross margin ( 90 ) 36. 70/ 6) 36. 490 35. 29/0 35. 290 Marketing & selling 1210. 8 1 , 199.0 1 , 083 . 1 1 , 030. 2 GOLA expenses 586. 2 570.7 560 . 0 569.0 EBITDA 712.5 687.` 589. 4 593. 0 EBI TDA margin ( 9/0 ) 10. 490 10. 20/0 9. 30/6 9.590 preciation 150 . 4 107 . 2 140. 3 150.4 EBT 562. 1 520. 1 449. 1 436.6 EBI margin ( 90 ) 8. 29/0 7. 7 %0 7. 196 7. 090 Taxes 222.0 205.4 171.4 17 2.5 Net Income* 340 . 1 314 .7 271. 7 264 . 1 Return on sales ( 90 ) 5. 09% 4. 79/} 4. 30/6 4. 290 Dividends 150. 0 150.0 150. 0 150.0 Retained earnings 190 . 1 164. 7 121 . 7 1 14 . 1 Use outside these parameters is a copyright violation .` Authorized for use only in the course Financial Economics at Royal Holloway , University of London taught by Shareen Holmer from Sep 28 , 20 14 to Mar 31 , 2015 . Appendix 2. Saito Solar , Balance Sheets* ( millions of Yen , as of June 30 ) Assets 2009 2010 201 1 2012 Cash 120. 3 83.3 40.6 140. 7 Accounts Receivable 1 , 828. 0 1 , 895. 7 2, 045.0 2 , 121 . 3 Inventory* 1 , 127 .7 1 , 100. 8 1, 010. 2 1 , 065. 1 Prepaid Expenses \\91. 0 3 , 173.6 DO . I 89 . 2 95 . 8 Current Assets 3 , 169.9 3 , 185 . 0 3, 422.8 Net Fixed Assets 2, 210. 1 2, 250. 2 2, 240 . 0 2, 090. 2 Total Assets 5, 383.7 5, 420. 1 5, 431. 0 5, 513.0 Liabilities & Net Worth 2009 2010 201 1 LUIS Accounts Payable , 270.6 1, 098. 2 1, 001 . 1 909. 2 Accrued Expenses 143.0 187 . 1 _174.0 143. 2 Current Liabilities* 1 , 413.6 1 , 285. 3 1 , 175 . 1 1 , 142.4 Equity 3. 970.1 4, 134. 8 4. 256.5 4, 370. 6 Liabilities @ Net Worth 5 , 383.7 5 , 420 . 1 5 , 431.6 5 , 513.0 ( ] A06 - 13- 0020Appendix 3 . Saito Solar , Projected Profit & Loss and Cash Flows* ( millions of Yen , year ending June 30 )| Actual Projected Income Item 2012 2013 2014 2015 2016 2017 Sales 5 , 234 . 1 1 792.0 9, 351 . 2\\ 10 , 753.8 1 1 , 829. 2 12 , 420. 7 COGS 4 . 041 .9 4. 994.8 5. 993.8| 6 . 892.8 7. 582.1 7.961 . 2 Gross margin 2, 192 . 2 2, 797.8 3 , 357.4 3, 861.0 4 , 247 . 1 4 , 459.5 Gross margin ( 90) 35. 290 35. 990 35. 990 35. 9%0 35. 990 35. 990 " from Sep 28 , 20 14 to Mar 31 , 2015 . Marketing & selling 1 , 030. 2 1, 202.0 1 , 344. 2 1 , 504.4 1 , 722.9 1 , 875. 0 TOCA expenses EBITDA 569. 0 6.60. 2 960.0 593. 0 1 . 134 . 2 1 , 180. 2 735. 6 1 . 200. 0 1 , 053. 2 1 , 222.4 1 , 344. 0 1 , 384.5 EBITDA margin ( 9/0 ) 2.5% 12.090 1 1. 390 1 1. 490 11. 490 1 1. 190 Depreciation 150. 4 190.0 200. 0 220.5 250. 0 EBT 436. 0 761 . 2 863, 2 1, 022 . 4 1 , 123.5 1 , 134. 5 FBI margin ( 9/0 ) 7. 09% 9.8% 9. 290 9.506 9. 5 0/6 9. 10 0 Taxes 328. 0 388.5 4 20)." 431 . 1 Net Income ( NI ) 172.5 289.3 264. 1 472.0 535. 2 633. 9 696.6 703. 4 Return on sales ( 90 ) 4. 2% 6. 19/0 5. 7%0 5. 9% 5. 996 5. 79% Operating Cash Flows 420.5 646. 4 725.2 833.9 917. 1 953. 4 ( N1 + Depreciation ) Change in N WC ( 170. 4 ) ( 200.0 ) ( 210.0 ) ( 245.0 )| ( 260.0 ) ( 275.0 ) Change in CAPEX ( 50.0 ) ( 50.0 ) ( 50.0 ) ( 50.0 ) ( 50.0 ) Use outside these parameters is a copyright violation ." Free Cash Flow 250. 1 396. 4 $65 . 2 538.9 607 . 1 628. 4 Authorized for use only in the course Financial Economics at Royal Holloway . University of London taught by Shareen Holmer $ A06 - 13- 0020Appendix 4 . Discounting Future Cash Flows with Formulas* A firm's free cash flows can be in a variety of patterns , ranging from a simple single future cash flow to a complex mixed stream of projected cash Hows . Most , if not all , can be handled by one of the formulas below ." Generic DCF Formula CF . - ( 1 + + )" . PV = the present value of the cash flow stream* ` CFC = the cash flow which occurs at the end of year t* . I = the discount rate ( assumed to be constant over the project horizon )* I = the year , which ranges from one to 1\\ . I = the last year in which a cash flow occurs* . I denotes summation of the cash Hows as I goes from I to !` * Note that discount rate , opportunity rate , required rate of return , interest rate , capitalization rate , and weighted average `ost of capital ( WACO )` `C ) are terms used interchangeably by author's and practitioners . Fortunately , simpler versions ( shortcuts ) of the above formula exist , including : No Growth Perpetuity PT. ly in the course Financial Economics at Royal Holloway , University of London taught by Shareen Holmer from Sep 28 , 2014 to Mar 31 , 2015 * where OF is the constant perpetual cash flow and I = the discount rate . Use outside these parameters is a copyright violation .\\ Growing Perpetuity PV = _ CF ! 7 - 8 where CF , is the cash flow at the end of year one , I = the discount rate , and & = the growth rate .* Regular Annuity* PV = CFC - - * ( 1 + 7 j' where CF represents the steady end- of- year cash flow , I = the discount rate , and I = the number of constant cash Hows . The term in brackets is defined as an annuity factor , and facilitates more tedious algebraic computation .* Growing Annuity* PT = _| 1 - 1 HE Y - E L ( 1 + r ) where I = the discount rate , & = the growth rate , and I = the number of cash flows . Note that the formula above is Authorized for use only* simply the PV of a growing perpetuity" penalized by cash Hows foregone ." In all of these cases , cash flows are assumed to occur at the end of the year , and the formulas throughout represent* discrete ( vs . continuous ) time versions of these cash flows .\\ 8 A06 - 13- 0020