1. Complete attachedpro forma statements for the years 2015-2019, assuming an 8% growth rate for all line items. The cells that need to be completed are shaded in yellow.
2. The management of Netflix has approached your bank about borrowing $50,000,000 dollars in the form of a long-term bond. The bond would have a 30-year maturity and an 8% coupon rate. The first step is to calculate what the interest expense would be for this bond for Netflix on a monthly basis. Next, discuss what areas of the income statement and balance sheet would be impacted by this new debt and how. Finally, write a one page recommendation to your credit committee regarding the approval of this loan.
3. The management of Netflix has approached your bank about a line of credit. They are shopping for the largest line of credit and the best rate possible. Analyze the accounting statements and write a one page recommendation to your credit committee that includes if you think you should approve a line of credit; if so, how much, and a suggested interest rate. Explain your rationale and any assumptions you have made. Your summary should be at least 300 words.
4. Lastly, prepare an 8-10 slides PowerPoint presentation summarizing your findings that you could use to present to the credit committee.

#Microsoft Office User ##M#i#c#r#o#s#o#f#t# #O#f#f#i#c#e# #U#s#e#r# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #,#"TG Period Ending Total Revenue Cost of Revenue 31-Dec-14 5,504,656 3,752,760 Gross Profit 1,751,896 Operating Expenses Research Development Selling General and Administrative Non Recurring Others - Total Operating Expenses - 472,321 876,927 Operating Income or Loss 402,648 Income from Continuing Operations Total Other Income/Expenses Net Earnings Before Interest And Taxes Interest Expense Income Before Tax Income Tax Expense Minority Interest -3,060 399,588 50,219 349,369 82,570 - Net Income From Continuing Ops Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income Preferred Stock And Other Adjustments Net Income Applicable To Common Shares 266,799 - 266,799 266,799 31-Dec-13 31-Dec-12 4,374,562 3,609,282 3,117,203 2,652,058 1,257,359 957,224 378,769 650,243 329,008 578,224 - - - - 228,347 49,992 -28,131 200,216 29,142 171,074 58,671 474 50,466 19,986 30,480 13,328 - 87,274 - 17,152 - 112,403 - 17,152 - 112,403 17,152 2015 2016 2017 2018 2019 Period Ending 31-Dec-14 Assets Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Accumulated Amortization Other Assets Deferred Long Term Asset Charges 1,113,608 494,888 2,331,973 3,940,469 149,875 2,773,326 192,981 - Total Assets 7,056,651 Liabilities Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill 271,327 2,391,827 2,663,154 900,000 1,635,789 - Total Liabilities Stockholders' Equity Misc Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholder Equity 5,198,943 60 819,284 1,042,810 -4,446 1,857,708 Net Tangible Assets -915,618 31-Dec-13 31-Dec-12 604,965 595,440 290,291 457,787 - 1,858,358 1,492,713 3,058,763 2,240,791 - 133,605 - 131,681 - 2,091,071 - 1,506,008 - 129,124 - 89,410 - 5,412,563 3,967,890 162,453 139,607 - 1,991,750 1,536,319 2,154,203 500,000 1,424,799 1,675,926 400,000 1,147,291 - 4,079,002 - 3,223,217 60 552,485 - 56 440,082 - 777,441 3,575 301,616 2,919 1,333,561 744,673 2015 2016 2017 2018 2019 -757,510 -761,335