A friend wants to borrow money from you. He states that he will pay you $4,000 every 6 months for 8 years with the first payment exactly 3 years and six months from today. The interest rate is an APR of 6.3 percent with semiannual compounding. What is the value of the payments today

What are the forecasted levels of the line of credit and special dividends? (hints: create a column showing the ratios for the current year; then create a new column showing the ratios used in the forecast. also, create a preliminary forecast that doesn’t include any new line of credit or special dividends. identify the financing deficit or surplus in this preliminary forecast and then add a new column that shows the final forecast that includes any new line of credit or special dividend.) now assume that the growth in sales is only 3%. what are the forecasted levels of the line of credit and special dividends?