Question 1: (20 Marks)
In addition to the below balance sheet and income statement you are given the following information about MFI Sano.
Expected Inflation | 2.8% |
The market rate for commercial loans is | 12.0% |
The actual interest rate paid for subsidized loans is | 4.0% |
In-kind donations adjustments | $400,000 |
In-cash donations adjustments | $250,000 |
The table below reports the income statement and balance sheet of MFI Sano for 2014 and 2015:
Balance Sheet | ||
Dec. 2015 | Dec. 2014 | |
ASSETS | ||
Cash | 28,000 | 29,000 |
Investments | 83,000 | 95,000 |
Total loan portfolio | 832,000 | 625,000 |
(Loan loss reserve) | (55,000) | (50,000) |
Total net loans outstanding | 777,000 | 575,000 |
Fixed assets | 32,800 | 25,800 |
(Accumulated depreciation) | (10,500) | (9,000) |
Net fixed assets | 22,300 | 16,800 |
TOTAL ASSETS | 910,300 | 715,800 |
LIABILITIES | ||
Forced savings | 95,000 | 100,000 |
Commercial loans | 18,900 | 14,800 |
Subsidized loans | 48,500 | 29,500 |
TOTAL LIABILITIES | 162,400 | 144,300 |
EQUITY | ||
Donated equity cumulated | 448,000 | 410,000 |
Donated equity current | 0 | 50,000 |
Cumulated earnings/losses | 95,900 | (40,000) |
Current earnings/losses | 204,000 | 151,500 |
TOTAL EQUITY | 747,900 | 571,500 |
TOTAL LIABILITIES + EQUITY | 910,300 | 715,800 |
Income Statement | ||
Dec. 2015 | Dec. 2014 | |
OPERATING INCOME | ||
Interests and fees from loans | 410,800 | 395,000 |
Income from investments | 32,000 | 31,000 |
TOTAL OPERATING INCOME | 442,800 | 426,000 |
OPERATING EXPENSES | ||
Interest and fee expenses | 2,450 | 2,150 |
Loan loss provision expense | 36,200 | 25,200 |
Salaries | 251,125 | 168,000 |
Other administrative expenses | 38,000 | 42,000 |
Depreciation | 2,800 | 1,900 |
TOTAL OPERATING EXPENSES | 330,575 | 239,250 |
NET OPERATING PROFIT / LOSS | 112,225 | 186,750 |
NON OPERATING INCOME | ||
Cash donations | 0 | 60,000 |
Other non-operating income | 0 | 0 |
TOTAL NON OPERATING INCOME |
0 |
60,000 |
Non-operating expenses |
0 |
0 |
TOTAL PROFIT / LOSS | 112,225 | 246,750 |
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
Question 1: (20 Marks) In addition to the below balance sheet and income statement you are given the following information about MFI Sano.
Pro forma Income Statement & Balance Sheet for Radial Inc. This experiential exercise involves creating a pro forma Balance Sheet and a pro forma Income Statement for Radial Inc. Assume the current year is 2015. To assist you in this endeavor, an Excel worksheet containing Radial's 2014 Income Statement and Balance Sheet has been provided. Develop the two pro forma financial statements for 2015 based upon the following assumptions: The company plans to increase sales by an additional 2 percent...
Northstar Corp.'s income statement and balance sheet are given below. a) Express this information as vertical trend percents. Please make sure your final answer(s) are in percentage form and are accurate to 2 decimal places. (For example: 12.34%) Northstar Corp Income Statement Vertical Trend Percentages (%) 2016 2015 2014 2016 2015 2014 Sales $1,428,000 $1,202,000 $1,059,000 Cost of goods sold. 974,000 858,000 773,000 Gross profit from sales 454,000 344,000 286,000 Operating expenses. 290,000 235.000 194.000 Income before tax 164,000 109,000...
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,...
Exercise on EWS Bank ABC's simplified balance sheet position (in £ million) is illustrated below: ASSETS LIABILITIES Cash Liquid Assets 50 150 800 550 Retail deposits Wholesale deposits Subordinated debt Loan Loss Reserve Equity Securities Mortgages 200 600 90 500 50 Commercial Loans TOTAL 1500 TOTAL 1500 . . . The bank interest income was £750 and interest expenses £650 The non-interest income was £620 and non-interest expenses £600 The bank expects 10 per cent of commercial loans and 5...
Megalopolis Bank has the following balance sheet and income statement. For Megalopolis, calculate: Return on equity Return on assets Asset utilization Equity multiplier Profit margin Interest expense ratio Provision for loan loss ratio Noninterest expense ratio Tax ratio Balance Sheet (in millions) Assets Liabilities and Equity Cash and due Demand from banks $ 9,000 deposits $ 19,000 Investment securities 23,000 NOW accounts 89,000 Repurchase agreements 42,000 Retail CDs 28,000 Loans 90,000 Debentures 19,000 Fixed assets 15,000 Total liabilities $155,000...
Megalopolis Bank has the following balance sheet and income statement Assets Cash and due from banks Investment securities Repurchase agreements Loans Fixed assets Other assets Balance Sheet (in millions) Liabilities and Equity $ 10,000 Demand deposits 33,000 NOW accounts 52,000 Retail CDs 100.000 Debentures 25,000 Total liabilities 5,000 Common stock Paid-in capital Retained earnings $225,000 Total liabilities and equity $ 29,000 99,000 38.000 29,000 $195,000 12,000 4,000 14,000 $225,000 Total assets Income Statement Interest on fees and loans Interest on...
Lucas Corporation reported the following income statement and comparative balance sheet, along with transaction data for 2015 Lucas Corporation Balance Sheet December 31, 20X1 and 2014 2015 2014 Liabilities Assets 2015 2014 Current Current: Cash and equivalents.... $19,000 3,000 Accounts payable Accrued liabilities..... $ 35,000 $ 26,000 Accounts receivable...... 22,000 23,000 7,000 10,000 9,000 Inventories.... Income tax payable.... 34,000 31,000 10,000 Prepaid expenses.. Total current assets.... 45,000 1,000 Total current liabilities 52,000 3.000 44,000 76,000 60,000 Long-term note payable... 10,000...
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. April 26, 2019 $30,557 9,155 2,330 10,418 1,764 Consolidated Statement of Income, 12 Months Ended ($ millions) Net Sales Costs and expenses Cost of products sold Research and development expense Selling, general, and administrative expense Amortization of intangible assets Restructuring charges, net Certain litigation charges Other operating expense, net Operating profit Other nonoperating income, net Interest expense Income before income taxes Income tax...
Fill in all of the boxes to complete the financial statements Balance Sheet/(cost basis) 2014 2015 2014 2015 Assets Current assets Cash Market Livestock Liabilities Current Liabilities Accounts Payable Cur. Port term debt 50,000 20,000 70,000 65,000 48,000 113,000 10,000 40,000 50,000 13,000 46,000 59,000 Total Current assets Total Cur. Liabilities Non-current Assets Machinery Building Land Total NC Assets Non-current Liabilities Mortgage Total NC Liabilities 380,000 380,000 334,000 334,000 350,000 130,000 550.000 1,030,000 310,000 95,000 550,000 955,000 Total Liabilities 430,000...
1) Given the following financial information for 2014 and 2015, construct an Income Statement, Balance Sheet and Statement of Cash Flows for Grand Twins. - The Income Statement information is for the entire year. - The Balance Sheet information is for December 31 of each year. 2014 2015 Accounts Payable $2,065,168 $3,732,362 Accounts Receivable 47,677,904 53,413,866 Cash 5,786,943 1,260,691 Common Stock 27,280,000 27,280,000 Cost of Goods Sold 45,014,348 50,298,751 Depreciation Expense 975,000 975,000...