Starting Cash | ||||
Equity Investment | 10000 | |||
Purchase of equipment | -6500 | |||
Bank Loan | 25000 | |||
Starting Supplies | 2800*20% | -560 | ||
Opening cash | 27940 |
Starting Balance Sheet | ||||
Cash | 27940 | |||
Inventory | 2800 | |||
Fixed Assets | 6500 | |||
Total Assets | 37240 | |||
Accounts payable | 2240 | |||
Bank Loan | 25000 | |||
Equity | 10000 | |||
Total Liabilities | 37240 | |||
First Year Income statement | ||||
Revenues | 28,000 | |||
Vessels Expenses | -16,800 | |||
Shoreside expenses | -8,600 | |||
Operating Income | (Revenue - Expenses) | 2,600 | ||
Interest expenses | (Bank Loan * Interest Rate on Loan 25000*7%) | -1,750 | ||
Pre-tax income | 850 | |||
Taxes | 20% | -170 | ||
After tax income | 680 |
Expected change in Cash | ||||
Start | Change | End | ||
Cash | 27,940 | 0 | ||
Accounts receivable | 7,000 | 7,000 | ||
Supplies | 2,800 | 1,200 | 4,000 | |
Fixed Assets | 6,500 | 500 | 7,000 | |
Total Assets | 37,240 | 8,700 | 18,000 | |
Accounts payable | 2,240 | 5,850 | 8,090 | |
Bank Loan | 25,000 | -200 | 24,800 | |
Equity investment | 10,000 | 10,000 | ||
Retained earnings | 680 | 680 | ||
Debt & Equity | 37,240 | 6,330 | 43,570 | |
Difference in Totals | (Debt & Equity - Assets) | 25570 | ||
Minus starting cash | (Opening Cash) | -27940 | ||
Change to cash | -2370 |
Changes in Balance Sheet | ||||
Start | Change | End | ||
Cash | 27,940 | -2,370 | 25,570 | |
Accounts receivable | 7,000 | 7,000 | ||
Supplies | 2,800 | 1,200 | 4,000 | |
Fixed Assets | 6,500 | 500 | 7,000 | |
Total Assets | 37,240 | 6,330 | 43,570 | |
Accounts payable | 2,240 | 5,850 | 8,090 | |
Bank Loan | 25,000 | -200 | 24,800 | |
Equity investment | 10,000 | 10,000 | ||
Retained earnings | 680 | 680 | ||
Debt & Equity | 37,240 | 6,330 | 43,570 |
Please see the excel sheet attached. Question is on top of first page. inancial Statement wlth...
Please see question on top of the tables attached.
Gb699 Decision Making Model Enter formulas in the below cells. Afirm reported the financial data for one year. Prepare the balance sheet and income statement Complete the cash flow calculations. Column B Column C Column D ColumnE Row 10 Column A 10 Reported Data Cash Other assets Debt Capital Revenues Expenses Interest Taxes Dividends, percent of income Jan-17Dec-17 10700 37768 521000519000 11000 14000 520700542768 609950 544000 9975 20% 40% 12 13...
Dudley Bank has the following balance sheet and income
statement.
page 412
Income Statement
Interest on fees and loans $6,715
Interest on repurchase agreements 143
Interest on other investment securities 1,705
Interest on deposits in banks 60
Total interest income $8,623
Interest on deposits 3,018
Interest on debentures 1,140
Total interest expense $4,158
Net interest income $4,465
Provision for loan losses 200
Noninterest income. 950
Noninterest expenses 1,720
Income before taxes $3,495
Taxes 1,220
Net income 2275. For Dudley Bank,...
Goal: Create an Excel worksheet to prepare an income statement, a balance sheet and a statement of changes in equity for a start-up business. Scenario: You have started a valet parking business called First Class Valet. You have tracked your cash, supplies, revenues, expenses, and other items in a spreadsheet. The totals for each account at the end of your first month are as follows (ignore GST): 1. Sales Revenues, $400 2. Supplies on hand (asset account), $175 3. Cash,...
Please solve using the shown Workbook in excel
Balance Sheet & Income Statement Coast Ltd., which has just started trading on 1 January 2019. has the following account balances prior to the recording of the final month of the year: Account Balances as at 30 November 2019 Account $ Cash $5 300 Accounts receivable $6 400 Stock of Supplies $11 600 Property, Plant & Equipment -cost $36 000 Accounts payable $3 000 Interest payable S 100 Bank Loan $12 000...
Please show in excel like above,
thanks!
Balance Sheet & Income Statement Coast Ltd., which has just started trading on 1 January 2019. has the following account balances prior to the recording of the final month of the year: Account Balances as at 30 November 2019 Account $ Cash $5 300 Accounts receivable $6 400 Stock of Supplies $11 600 Property, Plant & Equipment -cost $36 000 Accounts payable $3 000 Interest payable S 100 Bank Loan $12 000 Contributed...
QUESTION 15 For the following question, please refer to the attached spreadsheet. This sheet contains income statements and balance sheets for McDonald's and Yum! Brands (Yuml owns fast food chains KFC, Taco Bell, and Pizza Hut). These financial statements are actual statements taken from the U.S. Securities and Exchange Commission's database--for those of you who have only seen financial data presented in a textbook, it may take a couple minutes getting used to the format. Which company provides a more...
Question 1 - The Income Statement Using Figure 2-1 on page 15 as your Income Statement form, review the following facts and prepare an Income Statement. Charlie's Chairs has the following expenses and sales revenue for the year: Cost of Goods Sold ----- $6,358,000 Income Tax Expense ---- $458,000 Interest Expense ---- $684,000 Wages Expense --- $2,500,000 Rent ----$500,000 Selling Expenses ---- $1,000,000 Depreciation ---- $300,000 Amortization ----$75,000 Sales Revenue ---- $13,125,000 Question 2 - The Balance Sheet Using Figure...
The 2018 Income Statement and Balance Sheet of Tampa Clinic, a not-for-profit organization, are presented below. Tampa Clinic Income Statement Year Ended December 31, 2018 Operating Revenues: Patient service revenue $524,630 Less provision for bad debts (27630) $497,000 Net patient service revenue Other revenue Net operating revenues 10,000 $507,000 Expenses: Salaries and benefits Supplies Insurance Depreciation Interest Total expenses Operating income Nonoperating income: Investment income Net income $231,950 76,050 16,700 8,000 41,000 $373,700 $133,300 S 2,700 $136,000 Tampa Clinic Balance...
help with 2-6. the Beginning and End Balance and Income Statement
is provided. Please and thank you.
New
Images below. help with 2-6
beginning balance sheet
end balance sheet
income statement
2. For the accounting period, does the data contained in the financial statements indicate that total revenue on a cash basis for the year too high or too low? Why? 3. What is the accrual adjusted revenue for the year? 4. For the accounting period, does the data contained...
Please complete in excel
The Statement of Cash Flows 989 P16-34A Preparing the statement of cash flows-indirect method with Learning Objective 2 non-cash transactions The 2015 income statement and comparaive balance sheet of Rolling Hills, Inc. follow 1. Net Cash Prov. by Op. Act. $125,700 ROLLING HILLS, INC. Income Statement Year Ended December 31, 2015 Sales Revenue $436,000 Cost of Goods Sold 202,200 Gross Profit 233,800 Operating Expenses Salaries Expense $78,400 Depreciation Expense-Plant Assets 14,400 Other Operating Expenses 10,200 Total...