Reference no: EM131077351
Case Study : Short-term Financial Planning
Introduction: Heavenly Reception
Heavenly Reception Limited is a local dealer for a national satellite television distributor. Recent growth has been very strong, but the company has to increase its financial leverage to deal with expansion. The high degree of financial risk is a concern to the company's controller as she prepares the budget for the coming fiscal year.
Assume the role of Abby Jeffers and prepare pro forma income statements, cash budgets, and balance sheets for Quarters 1, 2, 3, and 4 of 2004. Accompanying the budget should be a one-page memorandum which describes the changes in sales and cash flows each quarter, the financial decisions made, and if the company is in compliance with its ratio requirements.
The memo should be single-spaced and use the 11-point Arial font with .7 inch margins. All headings should be in12-point font and be bolded. Submit one Word file containing the memorandum and an Excel workbook file containing five worksheets: Input Data, Income Statement, Cash Budget, Balance Sheet, and Key Financial Ratios. The following templates for the pro forma financial statements should be used:
|
Income Statement
|
|
|
Q1
|
Q2
|
Q3
|
Q4
|
Year
|
|
Revenue Dish Sales Installation
Accounts Maintenance Fees Basic
Deluxe Optimal
Dish Maintenance
|
|
|
|
|
|
|
Income Statement
|
|
|
Q1
|
Q2
|
Q3
|
Q4
|
Year
|
|
Total Revenue Expenses
CGS
Selling Installation Maintenance Administration Depreciation Operating Income Interest Income Interest Expense Income Before Tax Income Tax
Net Income
|
|
|
|
|
|
|
Cash Budget
|
|
|
Q1
|
Q2
|
Q3
|
Q4
|
Year
|
|
Cash Balance, Beginning Cash Receipts
Dish Sales/Installation This Quarter
Last Quarter
Accounts Maintenance Fees Basic
Deluxe Optimal Maintenance Interest
Tax Refund
Total Cash Receipts Cash Disbursements Purchases
This Quarter Last Quarter Selling Installation
Maintenance
|
|
|
|
|
|
|
Cash Budget
|
|
|
Q1
|
Q2
|
Q3
|
Q4
|
Year
|
|
Administration Interest Income Tax
Regular Dividends Capital Purchases
Total Cash Disbursements Sub-total
Financing Borrowing Line-of-Credit Term Loan Repayment Line-of-Credit Term Loan Special Dividends
Issuance/Repurchase of Shares
Total Financing
Temporary Investment Cash Balance, Ending
|
|
|
|
|
|
|
Balance Sheet
|
|
|
Q1
|
Q2
|
Q3
|
Q4
|
|
Current Assets
Cash
Temporary Investments Accounts Receivable Satellite Inventory
Total Current Assets Property, Plant, & Equipment Equipment, Net
Total Assets Current Liabilities Accounts Payable Line of Credit
Current Portion of Long-term Debt Total Current Liabilities Long-term Liabilities
Term Loan Shareholders' Equity Common Shares Retained Earnings
Total Liabilities &Equities
|
|
|
|
|
|
Ratio Table
|
|
|
Q1
|
Q2
|
Q3
|
Q4
|
|
Current Ratio - 1.5 LOC/(A/R + Inventory)-1.0 Debt Ratio - .35
Times Interest Earned - 4.0
LOC Financing - $200,000
|
|
|
|
|
Attachment:- Assignment.rar
busn6021 case 2-heavenly reception.pdf
busn6021 case 2-introduction.pdf
|
Problem regarding the participant in the project
: Begin your response by describing your EAI scenario. Be sure to include your role or perspective on this project. Were you a participant in the project, a consumer of the project's result, or both?
|
|
Design a class to represent the database and another class
: For example, you could list people born in a given month. You should also be able to list everyone in the database
|
|
Find the eigenvalues and corresponding eigenvectors
: Math 121A: Homework 4. Find the eigenvalues and corresponding eigenvectors of the matrix. Show that if λ is an eigenvalue of an orthogonal matrix A with eigenvector v, then λ = ±1
|
|
What hormone might she be given to treat the osteoporosis
: What hormone might she be given to treat the osteoporosis? How does this medication help? How would this be effected by a low TSH?
|
|
Case study - short-term financial planning
: The high degree of financial risk is a concern to the company's controller as she prepares the budget for the coming fiscal year.
|
|
Solve the system using row reduction techniques,
: Math 121A: Homework 3. Alice, Bob, and Charlie are three siblings with ages a, b, and c respectively. Their combined age is 18 years. Solve the system using row reduction techniques, or otherwise
|
|
What issues or concernswould you raise regarding use of roi
: She has hired you as a compensation consultant. What issues or concernswould you raise regarding the use of ROI for evaluating the divisions and their managers?
|
|
Construct the transformer circuit in multisim
: Consider the circuit demonstrated in this week's presentations. With the turns ratio modified to 20:1, calculate the following values of Vs and Is for the given values of RL in the table below:
|
|
Organizational strategy and enterprise architecture
: For this assignment, you will be asked to to focus on a strategy: The College of IST wants to increase its enrollment by a total of 20% within the next three years. It wants you to provide ideas for each of Porter's four strategies.
|