work in excel

gardial green light, a manufacturer of energy-efficent lighting solutions, has had such success with it new producs that it is planning to substantially expand its manufacturing capacity with a 15 million investment in new machinery. Gardial plans to maintain its current 30% debt to total assets ratio for its capital structure and to maintain its dividend policy in which at the end of each year its distributes 55% of the year net income. this years net income was 8 million. how much external equity must Gardial seek now to expand is planned?