Charles was always a hands-on type of person. Within a couple of years of graduating from college,..

Charles was always a hands-on type of person. Within a couple of years of graduating from college, he started his own business. After some 20 years, it has grown significantly. He owns and operates Pro-Fence, Inc. in the Metroplex, specializing in custom made metal and stone fencing for commercial and residential sites. For some time, Charles has thought he should expand into a new geographic region, with the target area being another large metropolitan area about 500 miles north, called Victoria. Pro-Fence is privately owned by Charles; therefore, the question of how to finance such an expansion has been, and still is, the major challenge. Debt financing would not be a problem in that the Victoria Bank has already offered a loan of up to $2 million. Taking capital from the retained earnings of Pro-Fence is a second possibility, but taking too much will jeopardize the current business, especially if the expansion were not an economic success and Pro-Fence were stuck with a large loan to repay. This is where you come in as a long-time friend of Charles. He knows you are quite economically oriented and that you understand the rudiments of debt and equity financing and economic analysis. He wants you to advise him on the balance between using Pro-Fence funds and borrowed funds. You have agreed to help him, as much as you can. 1. For each funding option, perform a spreadsheet analysis that shows the total CFAT and its present worth over a 6-year period, the time it will take