{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-09-11T09:05:42-04:00", "answer_date": "2024-09-11 09:05:42", "is_docs_available": "", "is_excel_available": "", "is_pdf_available": "", "count_file_available": 0, "main_page": "student_question_view", "question_id": "10249339", "url": "\/study-help\/questions\/please-solve-using-the-following-information-monthly-pro-forma-cash-10249339", "question_creation_date_js": "2024-09-11T09:05:42-04:00", "question_creation_date": "Sep 11, 2024 09:05 AM", "meta_title": "[Solved] please solve using the following informat | SolutionInn", "meta_description": "Answer of - please solve using the following information Monthly Pro Forma Cash Flow Assignment In the Module, download the Excel | SolutionInn", "meta_keywords": "solve,information,monthly,pro,forma,cash,flow,assignment,module,download,excel,file", "question_title_h1": "please solve using the following information Monthly Pro Forma Cash Flow Assignment In the Module, download the Excel File called Pro Forma Cash Flow Template,", "question_title": "please solve using the following information Monthly Pro Forma Cash Flow Assignment", "question_title_for_js_snippet": "please solve using the following information Monthly Pro Forma Cash Flow Assignment In the Module, download the Excel File called Pro Forma Cash Flow Template, which contains a template to complete the assignment Using the PowerPoint example as a guide, complete the spreadsheet for 2017 based on the assumptions outlined below The theme park in our original PowerPoint example generated EBITDA of $40 million and did not incur any cash flow issues in 2016 In the assignment, the theme park fell on hard times and is projecting EBITDA of only $26 million for 2017 Based on the cash flow data presented below, develop a monthly pro forma income statement and cash flow budget for 2016 using the template provided Students should identify the months where the cumulative deficit falls below $7 million, which is all the cash the theme park has Income Statement Data $26 million in EBITDA is distributed as follows January through April 5 each month May and June 10 each month July and August 15 each month September and October 10 each month November and December 5 each month Depreciation is $1 million per month Interest Expense is $6 million per year The combined state and federal tax rate is 35 Timing Adjustments Annual interest expense consists of $3 million bond interest payments due on March 15 and September 15 Annual licensing fees of $2 4 million are due on July 1 Annual liability insurance premium of $6 million is due on September 1 Quarterly real estate tax payments of $1 8 million are due on February 1, May 1, August 1, and November 1($7 2 million in total) Investing and Financing Cash Flows $5 million bond principal repayments are due on February 1 and August 1($10 million for year) $6 million in restaurant renovations are paid in equal monthly installments Maintenance capital expenditures are $750,000 per month (59 million for year) The theme park would like to pay dividends of $2 million per quarter on March 15, June 15, September 15, and December 15 ($8 million in total) 0 2004 Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total THEME PARK 2016 PROJECTED MONTHLY CONDENSED CASH FLOW (S in Millions) Jan Feb Condensed Income Statement EBITDA Depreciation Expense Interest Expense Pre Tax Income Income Tax (Provision) Benefit Net Income Timing Non Cash Adjustments Add Back Depreciation Expense Interest Expense (Semi Annual) Licensing Foe (Annual) Insurance (Annual) Real Estate Taxes (Quarterly) DODOO OOOOOOOOOOOO Operating Cash Flow Investing Financing Cash Flows Bond Principal Repayment Restaurant Renovations Maintenance Capital Expenditures Dividends Monthly Cash Flow Surplus Defica) Cumulative Surplus (Deficit)", "question_description": "
please solve using the following information \"image <\/div>
\"image<\/div> <\/div> Monthly Pro Forma Cash Flow Assignment In the Module, download the Excel File called Pro Forma Cash Flow Template, which contains a template to complete the assignment. Using the PowerPoint example as a guide, complete the spreadsheet for 2017 based on the assumptions outlined below. The theme park in our original PowerPoint example generated EBITDA of $40 million and did not incur any cash flow issues in 2016. In the assignment, the theme park fell on hard times and is projecting EBITDA of only $26 million for 2017. Based on the cash flow data presented below, develop a monthly pro forma income statement and cash flow budget for 2016 using the template provided. Students should identify the months where the cumulative deficit falls below $7 million, which is all the cash the theme park has. Income Statement Data: $26 million in EBITDA is distributed as follows: January through April: 5% each month . May and June: 10% each month July and August: 15% each month September and October: 10% each month November and December: 5% each month .. Depreciation is $1 million per month Interest Expense is $6 million per year The combined state and federal tax rate is 35% Timing Adjustments Annual interest expense consists of $3 million bond interest payments due on March 15 and September 15. Annual licensing fees of $2.4 million are due on July 1 Annual liability insurance premium of $6 million is due on September 1 Quarterly real estate tax payments of $1.8 million are due on February 1, May 1, August 1, and November 1($7.2 million in total). Investing and Financing Cash Flows: $5 million bond principal repayments are due on February 1 and August 1($10 million for year) $6 million in restaurant renovations are paid in equal monthly installments Maintenance capital expenditures are $750,000 per month (59 million for year). The theme park would like to pay dividends of $2 million per quarter on March 15, June 15, September 15, and December 15 ($8 million in total). 0 - 2004 + Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total THEME PARK 2016 PROJECTED MONTHLY CONDENSED CASH FLOW (S in Millions) Jan Feb Condensed Income Statement EBITDA Depreciation Expense Interest Expense Pre-Tax Income Income Tax (Provision) Benefit Net Income Timing\/Non-Cash Adjustments Add Back Depreciation Expense Interest Expense (Semi-Annual) Licensing Foe (Annual) Insurance (Annual) Real Estate Taxes (Quarterly) DODOO OOOOOOOOOOOO Operating Cash Flow Investing\/Financing Cash Flows Bond Principal Repayment Restaurant Renovations Maintenance Capital Expenditures Dividends Monthly Cash Flow Surplus Defica) Cumulative Surplus (Deficit)", "transcribed_text": "", "related_book": { "title": null, "isbn": null, "edition": null, "authors": null, "cover_image": null, "uri": null, "see_more_uri": "" }, "free_related_book": { "isbn": "", "uri": "", "name": "", "edition": "" }, "question_posted": "2024-09-11 09:05:42", "see_more_questions_link": "\/study-help\/questions\/business-management-leadership-2023-June-05", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/study-help\/positive-psychology\/the-expressions-of-the-basic-emotions-reflect-both-universal-physiological-1992549", "description": "The expressions of the basic emotions reflect both universal physiological responses and cultural learning; people are usually less accurate at recognizing facial expressions of those from unfamiliar...", "stars": 0 }, { "url": "\/emmy-leaders-inc-reported-the-following-results-for-the-year", "description": "Emmy Leaders Inc. reported the following results for the year ending August 31, 2012: Retained earnings, September 1, 2011 ....$740,000 Net income ...............145,000 Cash dividends declared...", "stars": 3 }, { "url": "\/study-help\/questions\/please-solve-using-the-following-information-monthly-pro-forma-cash-10249339", "description": "please solve using the following information Monthly Pro Forma Cash Flow Assignment In the Module, download the Excel File called Pro Forma Cash Flow Template, which contains a template to complete...", "stars": 3 }, { "url": "\/study-help\/questions\/the-sources-in-a-references-page-should-be-listed-alphabetically-3491701", "description": "The sources in a references page should be listed alphabetically. ATrueBFalse", "stars": 3 }, { "url": "\/study-help\/questions\/the-casual-furniture-company-manufactures-outdoor-furniture-and-incurred-the-1001645", "description": "The Casual Furniture Company manufactures outdoor furniture and incurred the following costs during the month of January: $ Timber 31,998 Wages-assembly line personnel 19,499 Wages-factory supervisor...", "stars": 3 }, { "url": "\/study-help\/questions\/a-drug-trial-is-attempted-using-a-real-drug-and-1007480", "description": "A drug trial is attempted using a real drug and a pill made of just sugar. 18 people are given the real drug in hopes of increasing the calcium levels. The increase in calcium level is found to be on...", "stars": 3 }, { "url": "\/study-help\/questions\/1-using-the-tqm-philosophy-show-how-disney-or-any-1008873", "description": "1. Using the TQM philosophy show how Disney or any other company can benefit from implementing lean method so that customers can experience their value for money. 2. Provide recommendations on how...", "stars": 3 }, { "url": "\/study-help\/questions\/question-consider-the-following-figure-draw-the-bfs-tree-considering-999894", "description": "Question: Consider the following figure. Draw the BFS tree considering 2 as the source node and mark each level. If you have multiple options while traversing, pick the node with smallest index. Part...", "stars": 3 }, { "url": "\/study-help\/questions\/to-be-superior-to-similar-products-available-in-the-market-1008863", "description": "To be superior to similar products available in the market, products and services must possess a high level of quality. In different forms, most products come with assurances of quality, but are they...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/tempted-2240-the-following-information-relates-to-questions-16-10249338", "next": "\/study-help\/questions\/match-each-account-with-its-correct-normal-balance-normal-balance-10249340" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "please solve using the following information Monthly Pro Forma Cash Flow Assignment", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/please-solve-using-the-following-information-monthly-pro-forma-cash-10249339" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } } } }