Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the current debt percentage for this company, meaning the average percent of total capital that was debt during the entire forecast? ________% 2015
What is the current debt percentage for this company, meaning the average percent of total capital that was debt during the entire forecast? ________%
2015 | 2016 | 2017 | 2018 | |||
INCOME STATEMENT | ||||||
Revenue | ||||||
Rent | $ 100,000 | $ 110,000 | $ 121,000 | $ 133,100 | ||
Books | $ 30,000 | $ 32,445 | $ 35,089 | $ 37,949 | ||
Sandwiches | $ 7,000 | $ 7,931 | $ 8,986 | $ 10,181 | ||
Drinks | $ 6,000 | $ 7,107 | $ 8,418 | $ 9,971 | ||
COGS for Dinners | ||||||
Books | $ 15,000 | $ 16,223 | $ 17,545 | $ 18,975 | ||
Sandwiches | $ 3,500 | $ 3,966 | $ 4,493 | $ 5,090 | ||
Drinks | $ 3,000 | $ 3,554 | $ 4,209 | $ 4,986 | ||
Operating Expenses | ||||||
Rental Room Repair Labor | $ 20,000 | $ 22,000.00 | $ 24,200.00 | $ 26,620.00 | ||
Book Sales Labor | $ 5,000 | $ 5,407.50 | $ 5,848.21 | $ 6,324.84 | ||
General and Admin Expense | $ 25,000 | $ 25,750.00 | $ 26,522.50 | $ 27,318.18 | ||
Utilties | $ 10,000 | $ 10,300.00 | $ 10,609.00 | $ 10,927.27 | ||
Marketing | $ 5,000 | $ 5,150.00 | $ 5,304.50 | $ 5,463.64 | ||
Rental Room Repair Materials | $ 10,000 | $ 11,000 | $ 12,100 | $ 13,310 | ||
Depreciation Exp | ||||||
Building | $ 10,000 | $ 10,000 | $ 10,000 | $ 10,000 | ||
Furniture | $ 12,500 | $ 12,500 | $ 12,500 | $ 12,500 | ||
Mortgage Interest | $ 15,940 | $ 15,801 | $ 15,651 | $ 15,488 | ||
Extra Bank Loan Interest | $ 21,265 | $ 18,716 | $ 14,232 | $ 7,751 | ||
Taxable Income | $ (13,205) | $ (2,883) | $ 10,279 | $ 26,448 | ||
Taxes | $ - | $ - | $ 2,570 | $ 6,612 | ||
Net Income | $ (13,205) | $ (2,883) | $ 7,710 | $ 19,836 | ||
BALANCE SHEET | ||||||
Assets | ||||||
Minimum Cash Balance | $ 2,000 | $ 2,000 | $ 2,000 | $ 2,000 | ||
Extra Cash Above Minimum | $ - | $ - | $ - | $ - | ||
Accounts Receivable | $ 8,219 | $ 9,222 | $ 10,347 | $ 11,609 | ||
Inventory | ||||||
Books | $ 1,500 | $ 1,502 | $ 1,504 | $ 1,506 | ||
Sandwiches | $ 88 | $ 92 | $ 96 | $ 101 | ||
Drinks | $ 50 | $ 59 | $ 70 | $ 83 | ||
Land | $ 40,000 | $ 40,000 | $ 40,000 | $ 40,000 | ||
Buildings | $ 300,000 | $ 300,000 | $ 300,000 | $ 300,000 | ||
Furniture | $ 100,000 | $ 100,000 | $ 100,000 | $ 100,000 | ||
Accumulated Depreciation | $ 22,500 | $ 45,000 | $ 67,500 | $ 90,000 | ||
Total Assets | $ 429,357 | $ 407,875 | $ 386,518 | $ 365,300 | ||
Liabilities | ||||||
Taxes Payable | $ - | $ - | $ 2,570 | $ 6,612 | ||
Accounts Payable | $ 2,466 | $ 2,667 | $ 2,884 | $ 3,119 | ||
Mortgage | $ 98,329 | $ 96,520 | $ 94,560 | $ 92,438 | ||
Extra Bank Loan | $ 91,766 | $ 74,776 | $ 44,882 | $ 1,973 | ||
Equity | ||||||
Common Stock | $ 250,000 | $ 250,000 | $ 250,000 | $ 250,000 | ||
Retained Earnings | $ (13,205) | $ (16,088) | $ (8,378) | $ 11,457 | ||
Total Liabilties and Equity | $ 429,357 | $ 407,875 | $ 386,518 | $ 365,300 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started