Using Excel Prepare a classified Balance Sheet and Income Statement 3/01- sole propreitor contributed 350,000 cash to beachfront 14 beachfront 14 purchased a condominium to rent out condo cost 750,000. Allocated to 10% land 90% building, 30 year useful life Payment was 250,000 cash and 500,000 loan payable. 2.5% interest due march 1 and sept 1 each year 100,000 principle payment due june 1 each year mar-apr: 45,000 paid kitchen, baths, and improvements useful life 7 years 15,000 paid for furniture useful 5 years paid with cash may 1: all assets were placed in service and the condo was rented may-dec cash recieved: rent-91,782 rent deposits for next year-11,820 sales tax collected-12,880 may-dec cash paid: real estate and property taxes-8,694 sales tax-9,000 insurance-4,444 condo fees-6,400 resort fee-925 commissions-10,440 advertisments-514 utilities-6,669 cleaning-9,800 repair-6,716 paid interest on loan payable- 31 dec- cash balance- 86,630
Using Excel Prepare a classified Balance Sheet and Income Statement 3/01- sole propreitor contributed 350,000 cash to beachfront 14 beachfront 14 purchased a condominium to rent out condo cost 750,000. Allocated to 10% land 90% building, 30 year useful life Payment was 250,000 cash and 500,000 loan payable. 2.5% interest due march 1 and sept 1 each year 100,000 principle payment due june 1 each year mar-apr: 45,000 paid kitchen, baths, and improvements useful life 7 years 15,000 paid for furniture useful 5 years paid with cash may 1: all assets were placed in service and the condo was rented may-dec cash recieved: rent-91,782 rent deposits for next year-11,820 sales tax collected-12,880 may-dec cash paid: real estate and property taxes-8,694 sales tax-9,000 insurance-4,444 condo fees-6,400 resort fee-925 commissions-10,440 advertisments-514 utilities-6,669 cleaning-9,800 repair-6,716 paid interest on loan payable- 31 dec- cash balance- 86,630
Chapter9: Obtaining Affordable Housing
Section: Chapter Questions
Problem 5DTM
Related questions
Question
Using Excel Prepare a classified Balance Sheet and Income Statement
3/01- sole propreitor contributed 350,000 cash to beachfront 14
beachfront 14 purchased a condominium to rent out
condo cost 750,000. Allocated to 10% land 90% building, 30 year useful life
Payment was 250,000 cash and 500,000 loan payable.
2.5% interest due march 1 and sept 1 each year
100,000 principle payment due june 1 each year
mar-apr: 45,000 paid kitchen, baths, and improvements useful life 7 years
15,000 paid for furniture useful 5 years
paid with cash
may 1: all assets were placed in service and the condo was rented
may-dec
cash recieved:
rent-91,782
rent deposits for next year-11,820
sales tax collected-12,880
may-dec
cash paid:
real estate and property taxes-8,694
sales tax-9,000
insurance-4,444
condo fees-6,400
resort fee-925
commissions-10,440
advertisments-514
utilities-6,669
cleaning-9,800
repair-6,716
paid interest on loan payable-
31 dec-
cash balance- 86,630
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub