Please make income statement ,balance sheet, and cash flow statement using the existing data in the text . There is No missing information
please answer question at the bottem using the case attached (in pics 1 and 2)
10:357 Done 3 of 3 WJP PARTNERS Projecting Financial Requirements Angela Martin is a sophomore English major attending Central State University, a small liberal arts college in Missouri. She is president of the journalism club, which is where she first met her dorm roommate and good friend Ashlie Stegemoller. Stegemoller is a junior com- puter science major. Martin and Stegemoller have been discussing the possibility of a new business venture. After months of brainstorming, they have agreed to start a venture that would offer students and local businesses help in preparing term papers and reports. Both young entrepreneurs recently attended a local seminar entitled "How to Start a New Business." From this experience, they realized the need for preparing pro forma financial statements to obtain necessary financing and also to help them better visualize the merits of the venture. STATEMENT OF FINANCIAL ASSUMPTIONS Drawing on their findings, Martin and Stegemoller have made the following observations: 1. Sales projections related to the preparation of stu- dent reports and term papers are based on the fol- lowing assumptions: a. Eighty percent of the 12,000 students at the uni- versity, or 9,600 students, prepare at least two reports each 12-month period. This gives a pro- jection of 19,200 reports (9,600 x 2 = 19,200). b. The firm will get 3 percent of the student mar- ket in the first year, which will increase to 5 per- cent and 7 percent in the following two years, respectively, c. Student reports will average 16 pages in length for which the firm will receive $20 per report. 2. Revenue forecasts associated with the businesses needing the firm's services are based on the follow- ing assumptions: a. Sixty percent of the 100 local businesses will need at least 10 reports each 12-month period. b. The firm will obtain 6 percent of the business market in the first year, which will increase to 10 percent and 12 percent in the following two years, respectively. C. Business reports will average 30 pages in length, for which the firm will receive $40 per report. 3. On average, students will want one copy of their report in addition to the original; businesses will want five copies. The firm will charge $0.06 a page for copies RESEARCH FINDINGS Research indicates an unfulfilled demand for quality report-preparation services on campus. Market projec- tions estimate a potential volume of 19,200 reports a year from Central State's students. Additionally, there are over 100 small businesses within two miles of the university that have indicated an interest in the service. The majority of the students at Central State Univer- sity are enrolled in classes that require two or three reports each semester, ranging from 5 to 50 pages in length. The venture's secondary target market consists of businesses in the nearby city of Emmett, Missouri, which has an SMA (Standard Metropolitan Area) population of approximately 150,000. There are two office building complexes within two miles of the university, each con- taining over 50 small businesses. Case 10 WJP Partners 611 4. Practically all copies of reports will be bound, for a charge of $1 per copy. 5. The effective income tax rate will be 20 percent. The firm will extend credit to its business customers. Accounts receivable should be about 15 percent of annual business sales, and inventories should run about 12 percent of annual total sales. However, suppliers are expected to provide credit to the firm, which is estimated at 6 percent of annual sales. 7. The average cost of producing each report is esti- mated to be $12 in labor and $0.50 in materials. Martin and Stegemoller have an option for a rent- free office in the university's student activities building. This arrangement was negotiated based on an under- standing that they will provide the university with a spe- cial pricing schedule after 12 months of operation. The initial operation will include two personal com- puters with word-processing, spreadsheet, and database software. One laser printer and two photocopying machines will also be needed. The total equipment costs will be as follows: Financing is expected to come from the following sources: As the founders, Martin and Stegemoller will each invest $2,000 in the business. Additional equity will be raised in the amount of $4,000 from an outside investor: $3,000 will be invested at startup and the remaining $1,000 at the conclusion of the first year of operations. The National Bank of Emmett has agreed to loan the firm $3,000, to be repaid within one year, but with the option to renew each year, provided the business is doing well. The interest rate is expected to be 9 percent. The $17,000 in equipment will be purchased with a down payment of $7,000; the remaining balance will be paid off at $2,000 in principal per year, plus inter- est due on the remaining balance at an interest rate of 10 percent. QUESTION Given the above information, help Martin and Stege- moller prepare pro forma income statements, balance sheets, and cash flow statements for the first three years of their operation. Computers Printers and copiers Total equipment costs $12,000 $ 5,000 $17,000 The equipment will be depreciated on a straight-line basis over a five-year life expectancy
