Dianne Zélie May 31, 2021 Spreadsheet
Now switch to your Excel spreadsheet and select the entire data table which you have created as the basis of your invoice. Either click the ‘copy‘ button or simply right click and select ‘copy‘, then transfer to your Word document and place the cursor where you wish to paste the spreadsheet. What you do next really depends upon which version of Microsoft Word you are using. In Word 2007 you need to click the drop down arrow on the ‘paste‘ button, which is the first icon on the ‘home ‘ribbon. Now you need to select ‘paste special‘ and in the dialogue box choose ‘paste link‘ and select Microsoft Excel Worksheet Object. If you are using Microsoft Word 2003, click ‘edit‘ on the menu bar and select ‘paste special‘. The resulting dialogue box is the same as for Word 2007.
Lester‘s temporary office at the Factory was glassed on all sides, and surrounded by the sights, sounds, searing temperatures, and smells of the smelting and pouring areas. Originally, the cubbyhole had been used for storing coal and coke until the plant converted to gas-fired furnaces in the mid-‘50s. Over the next three decades a succession of plant superintendents used the room to boink their secretaries, which necessitated its windows being painted a squalid olive drab. During 10 years of performing this chore every six months, Lester had scraped two panes clear, so now he could gaze into the murky, smoky, smelly pit outside as he waited for the grinding computer and clackety printer to spit out a stream of spreadsheets.
Lester P. Goodbinder had suffered another agonizing week in Pittsburgh. The semi-annual audit he conducted at the Bourgeois Ball Bearing Factory stretched into five 14-hour days examining electronic spreadsheets on an archaic computer system installed in the early ‘80s. The equipment churned so abysmally he cleverly joked to himself it was powered by lazy hamsters on treadmills. Not only that, the accounting software loaded on the system was an early version of ”Abacus,” and only slightly faster than a key-punch adding machine but considerably slower than a hand-held calculator.
Unfortunately an internal rate of return is time dependent so the amount you can withdraw depends on when you take it. Suffice to say, the only way to calculate the amount you can take e.g. halfway through the life of the fund, is by trial and error. If you are evaluating a number of investment opportunities, that can be a very time consuming process. Therefore Microsoft have built the Goal Seek function to aid your spreadsheet development. Since Excel 2007, it has been available from the Data ribbon. In earlier versions of Excel, it was present from the Tools menu. It gets straight to the point. It asks you which value you would like to fix (in this case the investor‘s return), what you would like to fix it to, and asks what you would like to change. All fields can accept cell references. It will then calculate the input through trial and error.
The former hangs like a transparent curtain four feet above the floor and shrink-wraps itself to anyone bold enough to attempt passing through. The latter represents a fragrant blend of beer, cheap cologne, and unkempt toilets, and assaults an unsuspecting visitor‘s nose like an aggressive index finger. By Saturday, the fragrance would be pungent enough to cause mere mortals to speak in tongues. Lance led the way with Lester in tow, dodging around dark figures that emerged from the nicotine and odoriferous fog. Lester had difficulty keeping up, licking the lenses of his glasses and tie-drying them as they wove their ways toward diffused light they assumed was the bar area where lusty women awaited.
When presenting your business plan to an angel investor you must understand that they will be very interested in your spreadsheets and proformas, but you must also realize that it is typically an entrepreneurial optimistic approach, which causes problems with proformas. Therefore, you should have dueling spreadsheets; that is to say the spreadsheets, which take your best guess and double the time, double the expenses to compete with your optimistic approach. You should be able to present both of these to your Angel Investor; who chances are is a retired business person with a little bit of financial savvy.