Hello, I've attached all needed information. I need need:
1. The timings of the purchases as well as the source if possible
2. The rate if return.
Thank you. Please let me know if I need to clarify anything.
It appears that software packages costing about $25,000 initially are needed, and then there would be a 15% annual fee. This fee covers service, answering questions, and periodic updates. Another $30,000 would be needed for a contract with a software integration firm. Initial training of the firm's employees is estimated at $12,000, and about one-sixth of that as an annual expense. From looking at their history of software usage, they estimate that the life of this "generation" of software will be about 5 vears. software? If so, use their three memos and the firm's financial statements to define an acquisition plan. This plan should identify the timing of the purchases and the source of funds for the purchase. What is the rate of return of your proposal? From: Curly About: Projected Financial Impact of Integrating Data Flow between Packages Last year we lost four jobs with estimated billing of $45,000 because we could not meet client data flow expectations. We bid on and received jobs that covered 60% of these potential billings, and we were only out-of-pocket about $6000 in unbillable wages. Even this time was productively spent on an internal short course on changes in OSHA standards. I'm guessing, but I expect to lose two more jobs each year that we are without the integrating software. It will also become increasingly difficult to obtain other work. I would guess that a 10% to 20% drop in replacement billings would occur each year. Thus, next year I would expect 6 jobs to be lost, and that we would only be able to replace 40% to 50% of the billings. Since we do not really want to expand, I've not analyzed this as a problem in attracting new business. But we certainly do not want to reduce the scope of our operations, so I believe we should purchase the software. From: Mo About: Alternative Financing of Possible Software Purchases We all know that we've cut our margins to the bone on last year's bids. I still believe this was the right response to the downturn in construction in our part of the oil patch. We have managed to stay busy, but last year's profits and this year's projections are essentially zero. If it weren't for the payments on our building and the depreciation on it, both our cash flow and profit pictures would improve. You know I hate to borrow money, so that only leaves me with the option of bringing new stock into the business. We could attempt to bring in a fourth partner, but I would rather sell stock to some of our principal engineers and maybe even other long-term employees. Such a plan cannot be set up as profit sharing-we have none to share. Thus the most reasonable approach I see is that qualified employees (maybe everybody) be allowed to take part of their pay as stock. Then CML would match on a one-for-four basis. Thus someone who set aside $2000 in income over the year would be credited with $2500 in stock at the end of the year. I would guess that about half of the 40 cmployees would participate, although most would only make minimal contributions - at least at the beginning. They might average $100 to $200 each per month at the beginning. Thus, this plan could generate as much as $4000 per month. As I've thought about this idea 1 have become enthused because of the non-financial possibilities. If we could tie our best engineers into the long-term success of the firm, there might be less tumover. We do not have a serious problem. But, like the other design firms, we seem to keep our engineers for only two or three years (in most cases). I'd also like to reward people like Marcie who have been with us since the beginning. Thus, if this is set up as a share-the-reward and share-the-risk plan, I feel it can improve both morale and productivity. At the same time, it should allow us to buy the new software, as well as providing a structure to lower our costs if business gets even worse. From: Larry About: Bank Financing for the Software Programs The people at First Loutex have lots of faith in our ability to pay back any loans, but moncy is tight right now-so they want a pretty steep interest rate. They're also concerned about satisfying the auditors that any loans are sound. Consequently, they will probably insist that we use our equity in the building as collateral for any loan with a term over three years. We could switch to a new bank, but we know and like them and they know and trust us. It's just that with all the bad energy loans floating around and uncertainty in real estate, they have to be very cautious now. Maybe they'd relent some if we pushed, but I just don't know. Anyhow, they offered us up to $70,000 at 15% over three years or less. If we want more than three years, it'll cost us an extra $4500 in fees for securing the loan with our share of the building. They also want another 1% in interest. I've attached in Tables 33-1 \& 33-2 the income statement and balance sheet from last year. INCOME STATEMENT Year Ended December 31 BillingsBillablesalariesGrossProfitSelling,general,andadministrativeexpensesOperatingProfitDepreciationExpenseProfitBeforeTaxesTaxesonincomeLast$4,850,0001,840,0003,010,0001,700,000590,0001,250,00010,000(580,000)(525,000)4,000$,000(55,000)0Current$4,820,0003,120,000470,0001,230,000(55,000) BALANCE SHEET As of December 31 Assets Last Year Current Year Current Assets \begin{tabular}{lrr} Cash & $200,000 & $180,000 \\ Marketable securities & 50,000 & 50,000 \\ Accounts receivable & 1,390,000 & 1,440,000 \\ Inventory & 50,000 & 100,000 \\ Prepaid expenses & 20,000 & 25,000 \\ \cline { 2 - 4 } Total current assets & $1,710,000 & $1,795,000 \\ Property, plant, and equipment & 4,350,000 & 4,800,000 \\ less: Accumulated depreciation & 1,760,000 & 2,380,000 \\ & $2,590,000 & $2,420,000 \\ Total assets & $4,300,000 & $4,215,000 \\ \hline \end{tabular} Liabilities and Owner's Equity Current liabilities \begin{tabular}{lrr} Accounts payable & $520,000 & $540,000 \\ Taxes payable & 80,000 & 85,000 \\ Bank loan payable & 80,000 & 75,000 \\ Other payables & 80,000 & 130,000 \\ \multicolumn{1}{l}{ Total current liabilities } & 740,000 & 830,000 \\ & 1,320,000 & 1,200,000 \\ gage payable (interest at 9\%) & & \\ tal stock plus paid-in capital & 1,400,000 & 1,400,000 \\ , 000 shares outstanding) & 840,000 & 785,000 \\ ined earnings & $4,300,000 & $4,215,000 \end{tabular}